From: Andrew Moore Date: July 19 2012 11:02pm Subject: Re: Disable DB without deleting data List-Archive: http://lists.mysql.com/mysql/227858 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d04478937a91fcf04c536c77b --f46d04478937a91fcf04c536c77b Content-Type: text/plain; charset=ISO-8859-1 Revoke all privileges to it. No access, no use. On Thu, Jul 19, 2012 at 11:47 PM, Kirk Hoganson 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 > > --f46d04478937a91fcf04c536c77b--