List:General Discussion« Previous MessageNext Message »
From:Micah Stevens Date:April 12 2007 9:47pm
Subject:Re: renaming database
View as plain text  
Yeah, in SQL:

RENAME DATABASE start_name TO new_name;


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
renaming databaseOctavian Rasnita12 Apr
  • Re: renaming databaseMicah Stevens12 Apr
  • Re: renaming databaseGabriel PREDA14 Apr