http://dev.mysql.com/doc/refman/5.1/en/rename-database.html
This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23 well, as said: dump and delete or revoke permissions Am 20.07.2012 20:16, schrieb Rick James: > 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
signature.asc
Description: OpenPGP digital signature
