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 1298 satya dixit 05/04/2012 05:59AM
Re: renaming a mysql database 1105 Scott Nemes 05/04/2012 08:56AM
Re: renaming a mysql database 655 Rick James 05/05/2012 01:38PM
Re: renaming a mysql database 577 satya dixit 05/05/2012 08:46PM
Re: renaming a mysql database 608 Trey Raymond 05/14/2012 12:11PM
Re: renaming a mysql database 622 satya dixit 05/05/2012 08:59PM
Re: renaming a mysql database 521 Rick James 05/06/2012 10:28PM
Re: renaming a mysql database 725 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.