So after the past couple of weeks, its becoming clear that I need a better way of managing and organizing my SQL databases, at present, I have each database listed by site name, with a table underneath it like this:
domain
- tablename
But was wondering if there might be a better method, perhaps creating one 'primary' SQL database and then adding a slew of single tables below it:
maindatabase
- recipes
- cars
- pets
- forum
- store
- casino
- etc
Are there any drawbacks or bonuses to using either method over the other or, perhaps, any other methods you might have or currently use to handle database management that may be better still?
