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
1838
May 04, 2012 05:59AM
1357
May 04, 2012 08:56AM
878
May 05, 2012 01:38PM
827
May 05, 2012 08:46PM
822
May 14, 2012 12:11PM
872
May 05, 2012 08:59PM
752
May 06, 2012 10:28PM
1036
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.