Take individual MySQL database offline MySQL does not have any SQL commands or internal mechanisms for


making an individual database unavailable / offline
moving an individual database 


Thtis being the case, how can you take an individual database offline?
This may not be a suitable answer, but would achieve your goal...

What about, for the time you want it offline, renaming the database? This way, whatever application you have accessing the data would fail to connect to the database.

Moving the database can be achieved by 

mysqldump -u user -p database -c &gt; whatever.sql 


Then import whatever.sql into another server, finally dropping the original DB.