From: Micah Stevens
Date: April 12 2007 9:47pm
Subject: Re: renaming database
List-Archive: http://lists.mysql.com/mysql/206111
Message-Id: <461EA8FD.50603@raincross-tech.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>