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.reindl@stripped]
> 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.reindl@stripped>
> >>
> >> 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
