No. RENAME DATABASE does not exist. It may have something to do with internal table numbers in InnoDB.
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.reindl@stripped]
> Sent: Friday, July 20, 2012 2:51 AM
> To: Johan De Meersman
> Cc: firstname.lastname@example.org
> Subject: Re: Disable DB without deleting data
> Am 20.07.2012 11:20, schrieb Johan De Meersman:
> > ----- Original Message -----
> >> From: "Reindl Harald" <h.reindl@stripped>
> >> impossible with innodb
> >> * dump
> >> * delete
> >> with myisam you could stop the server and move the databasedir do
> >> 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,
> > 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