List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:April 7 2009 9:01am
Subject:Re: Rename InnoDB database
View as plain text  
Hi shuly,

1 Use innodb_file_per_table.
2 Create new database.
3 Take the dump of old database.
4 Restore in new database.
5 Drop old database.

On Mon, Apr 6, 2009 at 9:50 PM, Shuly Avraham <shuly@stripped> wrote:

> Hi,
>
> I need to rename a database having InnoDB tables.
> MySQL version is: 5.0.24-standard - so I cannot use the 'mysqladmin rename'
> option.
> What would be the best approach for doing this?
>
> Thanks,
> Shuly.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Krishna Chandra Prajapati

Thread
Rename InnoDB databaseShuly Avraham6 Apr
  • Re: Rename InnoDB databaseDing Hao7 Apr
    • Re: Rename InnoDB databaseShuly Avraham7 Apr
  • Re: Rename InnoDB databaseKrishna Chandra Prajapati7 Apr