Run multiple WordPress installations from a single MySQL database

14 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 :D

    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

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

(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

Rate this:

Speakers

Kenneth Watt 2

Language

English 2109

Download
MP4: Low, Med, High
OGG: Low
Subtitles
Subtitle this video →
Follow

Get every new post delivered to your Inbox.

Join 11,592 other followers

%d bloggers like this: