Install Multiple WordPress Installations Using a Single Database

Sometimes more than one WordPress installation is necessary on a single site and WPMU(WordPress’s multi-site solution) would be overkill, or sometimes a hosting provider limits the number of available databases per account, or maybe you just want to keep things more organized rather than have a bunch of databases scattered everywhere.

In any case, you’ll want to install multiple instances of WordPress, each one using the same database. Luckily, this is quite simple to do, but you must install WordPress manually in order for it to work properly. A majority of the one click installations (most common is Fantastico) do not allow you to specify the prefix to use and this is absolutely necessary to be met with success.  I have read a lot of code heavy ways to do this, but if you are testing out different blogs, only hosting a few, or trying to show a client a blog from your main site, then the solution is really simple.  All you need to do is modify your wp-config.php file, and find the line (roughly around line 52) that show the default database prefix as the wp_ prefix – and change it to something different.

So, I am assuming that you are already familiar with how to install WordPress.  To set up separate WordPress blogs, you should first create a new directory on your web server for the new files.  If I was going to create a separate fitness blog on my site, I would call the directory fitness.  The overall URL string would look like:  www.bradmerritt.com/fitness.

The second thing I would do is to FTP all of the most recent WordPress files to this new directory.  Now, I would open the config.php file in this new directory, and here is where I would change the databse default wp_ line of code to match my new blog.  For example – I might install wordpress for this site with a database prefix of wpbrad_, and then I might install another version on my server for a fitness site as wpfitness_ 

So for this example, I would change the default wp_ line of code to say wpfitness_, and then also add the database  name, database hostname, username and password like normal.

Lastly, just go out to the new blog directory and run the admin like usual www.bradmerritt.com/fitness/wp-admin (not a real URL).

When it comes time to install another blog using the same database, be sure to repeat the steps being certain to replace the wp_ prefix with something unique for the installation. That’s really all there is to it!

Related posts:

  1. Multiple WordPress installations on a single database
  2. WordPress URL directory Change
  3. How to Change Absolute Links
  4. Exporting and Importing WordPress Databse
  5. WordPress Plugins I love
  6. WordPress 3.0.1 Image Upload Error
  7. WordPress 1and1 Server 500 Internal Server Errors and NexGen Gallery
  8. Change Role Names or Add new Roles in WordPress
  9. How to decode encrypted WordPress footers
  10. WordPress Perma Links Setting
  11. Offering More Subscription Options
  12. How To Remove Author Details from posts In WordPress Blog
  13. How to Create Multiple Streams of Income
  14. Word Press Error 404
  15. Blogs
  16. Firearms
  17. WordPress
  18. Solar Power
  19. Sugru
  20. DIY
  21. Developing iPhone Apps
  22. Blogs
  23. Health and Fitness
  24. Private: Sites
  25. Solar Power/Alternative energy House Project
  26. Private: Privacy
  27. Photography

12 comments

  1. great share, great article, very usefull for me…thank

    you

  2. bolaabipS says:

    Just want to say what a great blog you got here!
    I’ve been around for quite a lot of time, but finally decided to show my appreciation of your work!

    Thumbs up, and keep it going!

    Cheers
    Christian, iwspo.net

  3. good share, great article, very usefull for us…thanks!

  4. Your blog is very usefull and with all information what I needed. So thank you and good luck!!!

  5. I agree with your Blog and I will be back to check it more in the future so please keep up your work. I love your content & the way that you write. It looks like you’ve been doing this for a while now, how long have you been blogging for?

  6. Was an interesting article, thank you..

  7. Dong Sewer says:

    Could you pls provide more information on this subject??? By the way your website is wonderful. Sincerely.

  8. Thanks for

    your sharing, it’s very useful

  9. I hope you will keep updating your content constantly as you have one dedicated reader here.

  10. Denisha Folk says:

    I always like to have a read about such things, my blog is related if you want to have a look round it please feel free. I have added yours to my bookmarks.

  11. Minna Klez says:

    Pretty nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed browsing your blog posts. In any case I’ll be subscribing to your feed and I hope you write again soon!

  12. hey great information your site contains will return when I have time to read more.

Leave a Reply