Re: renaming database

[Micah Stevens]

Yeah, in SQL:

RENAME DATABASE start_name TO new_name;

-Micah

On 04/12/2007 01:34 AM, Octavian Rasnita wrote:
> Hi,
>
> How can I rename a database if it contains InnoDB tables?
>
> I have tried renaming the directory where it is located, but it 
> doesn't work this way.
>
> Is there a method that works faster than dumping it with mysqldump 
> then re-create it under another name?
>
> Thanks.
>
> Octavian
>
>