Run multiple WordPress installations from a single MySQL database

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

  1. Ian

    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.

    Like

    • Ian

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

      Like

      • Ian

        Of course, it could be like

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

        or something completely different.

        Like

      • Ian

        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.

        Like

  2. Gareth

    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

    Like

  3. Borna

    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_

    Like

  4. raiderhost

    a long times not visit this sites 😀

    this a a cool tutorial.

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

    Like

  5. Ian

    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.

    Like

    • Michael Pick

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

      Like

  6. Ian

    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.

    Like

  7. Sammie Jecmenek

    Merci beaucoup pour les eclaircissements ! 🙂

    Like

  8. Yannis

    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.

    Like

Continue the discussion

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Published

February 24, 2009

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.

Rate this:

Speakers

Kenneth Watt 2

Tags

database 27
multiple installations 3
MySQL 8

Language

English 5452

Download
MP4: Low, Med, High
OGG: Low
Subtitles
Subtitle this video →
Producer
%d bloggers like this: