Installing WordPress multiple times on the same site is real easy. There may be times you want to have two different installs of WordPress on one domain. You can install WordPress on the root of your domain, on a subdomain or in a subdirectory or on all of the above. These, however, will function as completely separate blogs.
If you can create multiple MySQL databases then it’s a pretty straightforward approach just create a new database for each install. But what if you have a limited number of MySQL databases? You can share the database of one WordPress blog with multiple blogs. It just takes one little change in the wp-config.php file to work.
After you have created the new directory for the new WordPress blog you can simple copy the files from the existing blog over to the location of the new blog. But, and this is a very important step to do before the actual install steps! You need to change, or actually create a new database table prefix for the new blog. So before you go through the install steps on the new blog open the wp-config.php file of the new blog and change it.
When you open the wp-config.php file there actually are instructions right in the file to tell you what to do, look for this:
// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!
The part you want to change is the ‘wp_’ part. Make it anything you want and I suggest making it something that corresponds to the new blog so you can easily reference it if you ever need to do any database maintenance.
