Page 1 of 1

How to manage 100's of tables?

Posted: Tue Feb 13, 2007 11:57 pm
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?

Posted: Wed Feb 14, 2007 12:00 am
by Kieran Huggins
split each client into their own DB?

Posted: Wed Feb 14, 2007 12:07 am
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?

Posted: Wed Feb 14, 2007 7:26 am
by feyd
Keep the backup as an export, drop the live database.