Install two or more wordpress blogs in a single database

Posted on 18. Nov, 2008 by Joel in Tutorials, WordPress

You might have your blog hosted with a host provider who only provides you with limited databases. Say about 5 - 15 but not more than that and you got to pay extra for an additional database. But you don’t have to worry about it now anymore. This tutorial will guide you on how you can install two or more WordPress blogs in a single database. Yeah that’s true! This might be a pretty old and simple trick but if your are not aware of it just go ahead reading it.

First of all this only works when you install WordPress manually. So be cautious with what you are going to do.

During the installation process you need to modify your wp-config.php file and change the default wp_ prefix to something else. This is a bit technical but don’t worry I’ll make you feel easy =) Follow the step-by-step procedure.

Here’s a step-by-step procedure:

Step 1: Open wp-config.php

Step 2: Look for a line which says - table_prefix = ‘wp_’;

Step 3: Replace wp_ with anything you want.
For example - table_prefix = ‘wpblog2_’;

Step 4: Save the file

Step 5: Run the installer

And your done with it! Pretty simple huh! So be sure that next time you wanna integrate another blog with a single database, you just need to replace the prefix to some other name.

Wanna go deep into it and know more about it? Head over here.

Share it!