Use of databases

Currently I'm with a webhost that offers me unlimited mysql databases. The truth is better I was only offered about 5 because I only had 3 and today I started moving all my tables to one. Can anyone tell me why it is bad to put all your tables in one database? I can't really find a good reason.

it isn't good, bad or indifferent. It is simply a way to organize your data. Multiple database allows you to seperate and isolate your data - you can have the same table names used in different databases. A single database allows for better interconnectivity between the tables - but you will need longer table names to see what they relate to.

Think of it this way - you can place everything into you web server public_html directory or you can break it out to various directorys.

lig more or less right - multiple databases can just be cleaner in many cases if your needs are complex (various access to data, replication of some data but not others, etc.)



I don't believe this is true. There is no real difference in joining tables in multiple databases vs. joining tables in the same database as long as they are on the same server.

Ok, I thought that having only one db could cause adverse performance in terms of db operations but since it doesn't then I'll keep all my tables for one website in one db. thank you guys for the info.