Re: Disable DB without deleting data

2012-07-20 Thread Andrew Moore
omething to do with > internal table numbers in InnoDB. > >> Instead... > >> CREATE DATABASE new ...; > >> RENAME TABLE old.t1 TO new.t1, ... > >> DROP DATABASE old; > >> This should work cross-device. > >> > >>> -----Original Message

Re: Disable DB without deleting data

2012-07-20 Thread Reindl Harald
; From: Reindl Harald [mailto:h.rei...@thelounge.net] >>> Sent: Friday, July 20, 2012 2:51 AM >>> To: Johan De Meersman >>> Cc: mysql@lists.mysql.com >>> Subject: Re: Disable DB without deleting data >>> >>> >>> >>> Am 20.07.2012

Re: Disable DB without deleting data

2012-07-20 Thread Kirk Hoganson
: mysql@lists.mysql.com Subject: Re: Disable DB without deleting data Am 20.07.2012 11:20, schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" impossible with innodb * dump * delete with myisam you could stop the server and move the databasedir do not

Re: Disable DB without deleting data

2012-07-20 Thread Reindl Harald
ilto:h.rei...@thelounge.net] >> Sent: Friday, July 20, 2012 2:51 AM >> To: Johan De Meersman >> Cc: mysql@lists.mysql.com >> Subject: Re: Disable DB without deleting data >> >> >> >> Am 20.07.2012 11:20, schrieb Johan De Meersman: >>>

RE: Disable DB without deleting data

2012-07-20 Thread Rick James
:h.rei...@thelounge.net] > Sent: Friday, July 20, 2012 2:51 AM > To: Johan De Meersman > Cc: mysql@lists.mysql.com > Subject: Re: Disable DB without deleting data > > > > Am 20.07.2012 11:20, schrieb Johan De Meersman: > > > > - Original Message - > >&g

Re: Disable DB without deleting data

2012-07-20 Thread Reindl Harald
Am 20.07.2012 11:20, schrieb Johan De Meersman: > > - Original Message - >> From: "Reindl Harald" >> >> impossible with innodb >> >> * dump >> * delete >> >> with myisam you could stop the server and move the databasedir >> do not try this with innodb even with innodb_file_per_table! >

Re: Disable DB without deleting data

2012-07-20 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > impossible with innodb > > * dump > * delete > > with myisam you could stop the server and move the databasedir > do not try this with innodb even with innodb_file_per_table! Mmh, it should be pretty easy to write a small script that cr

Re: Disable DB without deleting data

2012-07-19 Thread Andrew Moore
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

Re: Disable DB without deleting data

2012-07-19 Thread Reindl Harald
Am 20.07.2012 00:47, schrieb Kirk Hoganson: > 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 database

Disable DB without deleting data

2012-07-19 Thread Kirk Hoganson
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 "detac