Some days ago, I decided to create a new blog for my upcoming podcast but there was only one MySQL database. So, I had to use it for 2, or even more, blogs. The solution came, as usual when it comes to programming, from my friend Panagiotis.

In fact, it is a real simple solution.

  1. Create a new subdomain
  2. Unzip wordpress inside the new subdomain
  3. Copy from the first blog the file “wp-config.php” locally
  4. Edit it by adding “$table_prefix = ‘new_db_name_’;”
  5. Upload the edited file to wordpress folder
  6. You are done
Really easy and simple after all! Thanks Panagiotis!
[photo via flickr.com, user oberazzi]
Tagged with:  

3 Responses to How to install multiple WordPress blogs with only one MySQL

  1. ErwinSK says:

    Hi, i whas seeking for a long time, is it realy SO simple?

    And what do i edit in de $table? The name of my subdomain?

  2. dkalo says:

    this solution refers to 2.6 wordpress installation. I don’t know if it will work in later versions. However, you can try it.

    You just have to add the name of the new database, whatever you want it to be.

  3. ErwinSK says:

    Okay… thanks, i found yesterday the plugin WP-hive. http://wp-hive.com/ fot just incase :-)

    Later….

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>