Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Mr Tech
Forum Contributor
Posts: 424 Joined: Tue Aug 10, 2004 3:08 am
Post
by Mr Tech » Tue Feb 13, 2007 11:57 pm
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?
Kieran Huggins
DevNet Master
Posts: 3635 Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:
Post
by Kieran Huggins » Wed Feb 14, 2007 12:00 am
split each client into their own DB?
Mr Tech
Forum Contributor
Posts: 424 Joined: Tue Aug 10, 2004 3:08 am
Post
by Mr Tech » Wed Feb 14, 2007 12:07 am
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?
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Feb 14, 2007 7:26 am
Keep the backup as an export, drop the live database.