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.