How to manage 100's of tables?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Mr Tech
Forum Contributor
Posts: 424
Joined: Tue Aug 10, 2004 3:08 am

How to manage 100's of tables?

Post by Mr Tech »

I have 100's of tables in my phpMyAdmin and it's getting pretty hard to manage.

What is a good why to layout my databases?

At the moment, I put all my clients CMS tables in the one database which gets pretty messy and takes a while to load.

Any suggestions on how I should lay everything out?
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post by Kieran Huggins »

split each client into their own DB?
User avatar
Mr Tech
Forum Contributor
Posts: 424
Joined: Tue Aug 10, 2004 3:08 am

Post by Mr Tech »

So if I had 100 clients, I would have 100 databases?

I like to keep backups of everything so I don't really want to delete the databases after a job is complete which would cause it to clog up wouldn't you think? Or from your experience, is that ok?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Keep the backup as an export, drop the live database.
Post Reply