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]