Sometimes more than one WordPress installation is necessary on a single site and WPMU 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.
During the installation process*, when it comes time to modify your
wp-config.php file (or on the WordPress config options screen), make sure that you change the default
wp_ prefix to something different.
I prefer using an identifier for the specific blog that WordPress is being installed on. For instance, if I were installing it for the OptiNiche website, I would use something similar to
wpon_ (i.e. WordPress OptiNiche).
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!
* If you’re not already familiar with the manual WordPress installation process, I highly recommend watching my WordPress installation video tutorial.