Re: Disable DB without deleting data

[Andrew Moore]

Revoke all privileges to it. No access, no use.

On Thu, Jul 19, 2012 at 11:47 PM, Kirk Hoganson <kirkhoganson@stripped>wrote:

> I need to find an easy way to make a database unavailable without deleting
> the data, so that it could be easily and quickly restored if necessary,
> without impacting the availability of the other databases.  Something like
> moving the databases subdirectory to a different directory, or the "detach"
> feature in MSSQL.  The MySQL server (5.0.45) is running on a Windows
> server, and is using the InnoDB storage engine.
>
> Thank you for any suggestions.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>