How to Umount single MySQL database
 

In SQL Server on Window$ one can unmount a single MySQL database (this is NOT the same as dropping a database) or bring it offline. This is valuable for testing and staging environments, and even production environments.

How can the same be done in MySQL? Can an individual database be unmounted or be brought offline, without having to actually DROP the database and re-create it?

AFAIK there is no such possibility in MySQL (at least 4.x).

You might try to revoke all permissions on that database and later grant them again.


regards
ric.

Thanks, Ric. That's one of the things I am trying to avoid. :( I'm surprised MySQL made it to version 4.x and in all that time they never saw the need or usefulness of being able to lock a database.