MySQL data migration related issues, all the. frm file Error ·

MySQL Data migration problem, all. frm file Error ·
MySQL Data migration problem, all. frm file Error ·

From the other side of the machine to copy the database directory files to the local computer, the data table can be seen, but query or look at the structure of the Times wrong:

#1033-incorrect information in file: ' Xxx.frm '





------Solution--------------------


What is your storage engine?
If it is MyISAM, the table file is represented by *. FRM, *. MYD, *. MYI, the three files are copied to the relevant database directory.
If it is InnoDB, then *. FRM contains only the definition of the table, the data file in Ibdata1, you need to copy the original idbdata1, Ib_logfile0,ib_logfile1, or any other file.

------Solution--------------------
• Dual-line host 100m/35 yuan/year, free to send the database (optional my/mssql)
• For more information, please visit: http://www.515dns.com

------Solution--------------------
If the database version is the same,
Sometimes it's necessary to fix
------Solution--------------------
Database Crash FIX:
Http://doc.99net.net/doc/database/1076488199/1076563963.html
Database configuration file My.ini Setup issues:
Add the Skip-innodb in front of the My.ini, comment out the restart MySQL


Reference http://topic.csdn.net/u/20090101/10/c8980f8e-8909-4ed0-82cc-22ef22e07189.html
------Solution--------------------
discuss
What is your storage engine?
If it is MyISAM, the table file is represented by *. FRM, *. MYD, *. MYI, the three files are copied to the relevant database directory.
If it is InnoDB, then *. FRM contains only the definition of the table, the data file in Ibdata1, you need to copy the original idbdata1, Ib_logfile0,ib_logfile1, or any other file.

