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
