Skip navigation links

MySQL Forums :: InnoDB :: renaming a mysql database


Advanced Search

renaming a mysql database
Posted by: satya dixit ()
Date: May 04, 2012 05:59AM

Hi i need some help here.
my requirement is to rename a database. but i could not manage to do that.

so i created another db and moved all files it to the new one. myisam tables are ok but mysql can't find innodb tables as the .frm copy inside ibdata1 probably holds diff info than the one inside the data dir.

pls help..

Options: ReplyQuote


Subject Views Written By Posted
renaming a mysql database 1245 satya dixit 05/04/2012 05:59AM
Re: renaming a mysql database 1072 Scott Nemes 05/04/2012 08:56AM
Re: renaming a mysql database 644 Rick James 05/05/2012 01:38PM
Re: renaming a mysql database 563 satya dixit 05/05/2012 08:46PM
Re: renaming a mysql database 598 Trey Raymond 05/14/2012 12:11PM
Re: renaming a mysql database 592 satya dixit 05/05/2012 08:59PM
Re: renaming a mysql database 504 Rick James 05/06/2012 10:28PM
Re: renaming a mysql database 695 satya dixit 05/07/2012 04:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.