Re: Experience with many schemas vs many databases

undisclosed user wrote:
> If I were to switch to a single DB/single schema format shared among 
> all users , how can I backup each user individually?

depending on how many tables, etc, I suppose you could use a seperate 
series of SELECT statements ...
but if this is a requirement, it certainly puts constraints on how you 
organize your data.   without a much deeper knowlege of your 
application, data, and requirements, its kind of hard to give any sort 
of recommendations.   you mentioned myISAM, so I gather this data isn't 
at all transactional, nor is relational integrity a priority.