Multiple Databases?

[KillerPanel]

I have a question on creating databases. When I create databases is it smarter to use a separate one for each installation on the site? For example, sometimes I install WordPress in the root and also in a subfolder. Should I use just one database for both or are there any advantages/disadvantages to creating two separate DBs?

[Bakeron]

I'm not an expert but I think you should create one database for each installation. Also separate the users. I believe this will increase the security as well.

[ronniev]

I have a question on creating databases. When I create databases is it smarter to use a separate one for each installation on the site? For example, sometimes I install WordPress in the root and also in a subfolder. Should I use just one database for both or are there any advantages/disadvantages to creating two separate DBs?

Yes, it is possible to install multiple blogs on the same database, please refer the advantages and disadvantages.

Advantages :

If you use the same configurations (i.e same database user name and passwords) for all your blogs on the same database then it will be easier for you to manage all domains.

Disadvantages :

1) If you use one database for multiple sites then it take more time for the queries to execute and may create load on the server and that is not recommended.
2) If in case the database got corrupted and it will affect all other blogs installed on the same database.
3) You need to take the backup of the entire database even if you want to take the backup for a single blog.

[KillerPanel]

Thank you very much for that detailed answer. That was exactly what I needed to decide. I can see that there are many disadvantages than advantages.

[ronniev]

Thank you very much for that detailed answer. That was exactly what I needed to decide. I can see that there are many disadvantages than advantages.

You are most