How-To
Run multiple WordPress installations from a single MySQL database
Description
(Best viewed with HD On in full screen)
If your hosting package only allows you one MySQL database, then this video is for you. Kenneth Watt (founder
of TechnoFinger) shows you how to edit your wp-config.php file so that multiple versions of WordPress can be
run on the one MySQL database.
Video by Kenneth Watt
Flavor
Language
Producer
MySQL, Kenneth Watt (2), installation
Speakers
Date
February 24, 2009
February 24, 2009 at 3:52 pm |
I have wanted something like this for a while so that blogs can get posts from the same source, but run independently, for example, alternative customised themes. However, Ken seems unsure at times and the resolution is too low to be able to view what he’s clicking on when he says things like “go to this address”… which address?! I can’t see it! Can his screen recording software not zoom in?
Also where do I enter the additional users in the config file? Also I see him change the table prefix, but where are the additional tables prefixes entered?
Personally I can comfortable set up an MySQL database and install WordPress and customise themes all manually, but I am still confused as to how run multiple WordPress installations from a single MySQL database.
February 24, 2009 at 4:06 pm |
Just noticed the “HD” button, I can read it now! Thanks Ken! Although I still don’t know how or where the addition table prefix should be entered. I don’t want to install multiple blogs and themes just only to find I did it wrong. Is it the same thing below the text that Ken edited like this:
table_prefix = ‘wp1_’;
table_prefix = ‘wp2_’;
table_prefix = ‘wp3_’;
February 24, 2009 at 4:09 pm |
Of course, it could be like
table_prefix = ‘wp1_’,‘wp2_’,‘wp3_’;
or something completely different.
February 24, 2009 at 4:23 pm |
Ken shows he has one database and three users. So where in the config file are the additional users and their passwords entered?
Ken also says “go to this address” which I now see is while selecting “bobbywel_wrdp1′ to get the authentication key before he switches to select the address. It’s like he speaks before thinking.
Ken also mentions one installation, but this video is about multiple WordPress installations.
Is the code: table_prefix = ‘wp1_’; – changed in the config file for each installation?
Sorry if I’m going on a bit, I’m just very frustrated having waited for the answer only to get something so unclear. I am sure others would like clarification.
February 24, 2009 at 4:41 pm
Hi Ian – sorry to hear you had some difficulties – maybe Kenneth will be able to answer your questions directly. In the meantime, for the extra info you’re looking for, you might want to check out this entry in the WordPress Codex.
February 27, 2009 at 4:06 pm
Hi Ian
If you need any help, feel free to email me at kennethwatt (at) technofinger.com
Kenneth
February 24, 2009 at 8:58 pm |
So how I understand this and the link Michael noted, the install would look like so and as I have tested quickly locally and successfully:
Each folder instance of wordpress will have one config file with one table prefix in the file.
Eg. Folder Structure:
Root/wp1 – Extracted WP
Root/wp2 – Extracted WP
Run each WP instance as being:
http://url/wp1/wp-admin/install.php
http://url/wp2/wp-admin/install.php
In my case for the quick test I have used the same username and password, which worked flawlessly at this point.
The API Key I have made different for my second instance….In my case my local test setup is:
Root = Main Instance (Was already in place and working)
Root/wp2 = New Test Instance
February 27, 2009 at 4:07 pm |
Hi Gareth
If you need any help, feel free to email me at kennethwatt (at) technofinger.com
Kenneth
March 1, 2009 at 1:18 pm |
You can also CHMOD WordPress folder into 777 then CHMOD back into normal. Then run the installer. And change table perfix field in *
* represents any text you want eg. wp_install_2_
March 2, 2009 at 5:31 pm |
a long times not visit this sites
this a a cool tutorial.
what benefit uses i mySQL for more wordpress or use wordpress MU ??
March 2, 2009 at 7:11 pm |
Why do I get told get to STFU? I’m just trying to understand it. I’ll email Ken with a question when I have a bit more time.
March 3, 2009 at 5:10 pm |
Hi Ian, that isn’t acceptable and must have slipped through moderation. The comment is now history. Apologies.
March 7, 2009 at 3:06 pm |
I installed two copies of WordPress with different posts in the first install. The config file in each connects to the same database and has a different table prefix in each. However the post in the second install shows just the default “Hello World” post.
Anyone know where I’m going wrong?! I’m hoping the same posts will be shown.
Thank you.