Would this keep permissions intact? I need something that would make it
easy to automatically restore the database including any custom permissions?
Thanks again for the input,
Kirk
On 07/20/2012 12:16 PM, Rick James wrote:
No. RENAME DATABASE does not exist. It may have something 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 11:20, schrieb Johan De Meersman:
----- Original Message -----
From: "Reindl Harald"<h.rei...@thelounge.net>
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 creates a
new database named<oldname>_offline and renames all tables into it,
no?
Shame that "rename database" doesn't exist any more :-)
my reply was to "Something like moving the databases subdirectory to a
different directory"
surely, you can rename the database
but if you want to move it to another mount-point you are lost with
innodb
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
