MySQL Forums
Forum List  »  Other Migration

Restoring migrating data from innodb, mysql 5
Posted by: Witali Plez
Date: August 13, 2011 05:33AM

Hi folks,

i am using mysql 5 and having the following issue. I never before used the mysqldump, because I learned that i can copy database and tables from one machine to another by moving the folder Data. (I know that it was not really correct.) It worked before, but does not now. I had computer crash and had to restore the data all over again. Now, after mysql 5 installation on the new machine, after copying folder Data, I got access to only those tables, which contain more that one files per table. But for those tables who got only tablename.frm i cannot read them:

error 1033 (HY000): incorrect information in file 'tablename.frm'

I know the tables should be there, but need to be restored somehow.

Anybode knows how to handle it, i would really appreciate.
Operational system is Windows 7, mysql 5.0.

Thx.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restoring migrating data from innodb, mysql 5
6641
August 13, 2011 05:33AM


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.