Restoring migrating data from innodb, mysql 5
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.
Subject
Views
Written By
Posted
Restoring migrating data from innodb, mysql 5
6798
August 13, 2011 05:33AM
2408
August 14, 2011 10:39AM
1890
October 12, 2011 09:27PM
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.