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
; 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
: 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
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:
>>>
: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
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!
>
- 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
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
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