Good database keeping (MySQL)

Associate
Joined
2 Aug 2005
Posts
680
Our host plan has given us 1 MySQL database. I want to be able to use this database for our website to store test results, comments etc. We also develop some websites for our customers, is it a bad idea to store their data in our database too, even if it's not related to our data in any way at all? This would save upgrading to the next plan up or buying extra databases, but I don't want to have a mess of data at the same time. Thanks.
 
yes it would be a bad idea, yes it means they can't run there own backups and restores, yes you'll end up with a messy database, yes it will work just fine ;)

You could always look at partitioning the database into multiple logical databases by uses different users and access rights for eack user.

HT
 
Back
Top Bottom