15 responses on “Run multiple WordPress installations from a single MySQL database”

1. Ian
   February 24, 2009 at 3:52 pm | Reply

   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.

   LikeLike
• Ian
  February 24, 2009 at 4:06 pm | Reply

  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_’;

  LikeLike
• Ian
  February 24, 2009 at 4:09 pm | Reply

  Of course, it could be like

  table_prefix = ‘wp1_’,‘wp2_’,‘wp3_’;

  or something completely different.

  LikeLike
• Ian
  February 24, 2009 at 4:23 pm | Reply

  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.

  LikeLike
• Michael Pick
  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.

  LikeLike
• Kenneth Watt
  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

  LikeLike
2. Gareth
   February 24, 2009 at 8:58 pm | Reply

   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

   LikeLike
• Kenneth Watt
  February 27, 2009 at 4:07 pm | Reply

  Hi Gareth

  If you need any help, feel free to email me at kennethwatt (at) technofinger.com

  Kenneth

  LikeLike
3. Borna
   March 1, 2009 at 1:18 pm | Reply

   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_

   LikeLike
4. raiderhost
   March 2, 2009 at 5:31 pm | Reply

   a long times not visit this sites 😀

   this a a cool tutorial.

   what benefit uses i mySQL for more wordpress or use wordpress MU ??

   LikeLike
5. Ian
   March 2, 2009 at 7:11 pm | Reply

   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.

   LikeLike
• Michael Pick
  March 3, 2009 at 5:10 pm | Reply

  Hi Ian, that isn’t acceptable and must have slipped through moderation. The comment is now history. Apologies.

  LikeLike
6. Ian
   March 7, 2009 at 3:06 pm | Reply

   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.

   LikeLike
7. Sammie Jecmenek
   December 14, 2010 at 5:24 pm | Reply

   Merci beaucoup pour les eclaircissements ! 🙂

   LikeLike
8. Yannis
   August 22, 2017 at 12:23 pm | Reply

   Hello All,

   I have noticed that the last post was made in 2010 but I am not sure if I am going to get any response however, I would give it a try, I guess 🙂

   I have posted the same thing on https://wordpress.stackexchange.com but I haven’t got a response yet.

   I am trying to implement the same thing as the video but instead of Blogs, I want to apply it to multiple eCommerce websites.

   I want to buy multiple domains and host on there different WordPress themes. However, I want them all to run under the same database.

   All of the websites will have a different theme however, the same WordPress database. Only of course, if there is something missing from the database to make the website in question function properly will be added to it.

   Now, all of the websites are going to be online stores/shops. Therefore, because I have gadgets that are much more expensive with much higher quality and that can cost in the $100s, I wouldn’t want to put it on the same website that I advertise the $1s or $10s etc.

   So, I want to create a generic database and use it on all of the websites

   The main concept of this, considering that I might add the same product on multiple websites, I want WordPress to mark as ‘sold out’ the product that was sold on a different website that I own.

   To break it down and make it easier below is an example;

   1) We have a website called abcd.com;
   2) We have another website called efg.com;
   3) Both websites are operating under the same database;
   4) Both websites advertise the same product with the same price;
   5) Once the product is ‘sold out’ on the abcd.com website, I would like the efg.com website to mark the same product as ‘sold out’ as well.

   All of the websites which are on different domains will run from the same server that I own and operate. Therefore, the database will be on the same server as the files are hosted on.

   I do not know how to get on with this however, before I go ahead and purchase the domains, I would like to find out if that is possible?

   Have any of you tried this before and if yes, how did you do it?

   Any help on this is appreciated.

   Thanks & Regards, Yannis.

   LikeLike