MySQL Forums
Forum List  »  InnoDB

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
2201
May 04, 2012 05:59AM
1578
May 04, 2012 08:56AM
1039
May 05, 2012 01:38PM
971
May 05, 2012 08:46PM
956
May 14, 2012 12:11PM
1040
May 05, 2012 08:59PM
869
May 06, 2012 10:28PM
1377
May 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.