Many people don’t know that they can create multiple WordPress blogs using one single database. This method is useful, if your hosting service provider strict the number of databases that you can use. All you need to do is simply change the table prefix in wp-config.php file.
If you don’t know anything about installing a WordPress blog then read WordPress manual and come here again.
To do this, open your wp-config.php file
Initially you’ll have something like this..
$table_prefix = ‘wp_’;
Change the “wp_” into something else (“myblog” or “main” or “cinema”) and upload it to the relevant directory. Then run the install. That’s it you can make multiple WordPress blogs in one Database.
But don’t forget that it may result in negative way as well. If your Database is crashed then all your blogs are gone. if you happen to have multiple databases for blogs then, even if one crash other sites will be up and running.
Have fun with WordPress