WordPress icon.

Vinícius Lira over in this comments thread has proposed a ridiculously elegant solution to using a default WordPress installation to host multiple blogs on different databases. If it works, it's genius.

  1. Create a subdomain that points to your WordPress installation, such as http://newblog.site.com/

  2. Create a new database, such as newblog

  3. Edit the wp-config.php file and replace:

    define('DB_NAME', 'wordpress');

    with:

    if($_SERVER['HTTP_HOST'] == "site.com" or
    $_SERVER['HTTP_HOST'] == "www.site.com") {
    	define('DB_NAME', "mysitedatabase");
    }
    elseif ($_SERVER['HTTP_HOST'] == "newblog.site.com") {
    	define('DB_NAME', "newblog");
    }
    

Haven't tested it myself yet, but it seems too simple. It shouldn't work. If it does, it'd be schweet.