Mysql reports error 1033 Incorrect information in file: ''' xxx. frm''' Solution to the Problem: 1033xxx. frm

Mysql reports error 1033 Incorrect information in file: ''' xxx. frm''' Solution to the Problem: 1033xxx. frm

Problem description

1. Database of the collection site

2. When there is no data, there is no problem with migration. If there is any data collected before migration, an error is reported in some menus.

Solution Process

0. Various du Niang, Gu Ge, fruitless.

1. The original site database version 5.0 and the new home database version 4.2 are incorrect. reinstall the environment. Invalid.

2. the backup provided by the customer is the source data under mysql/data, because ye Yu did not do this during Backup. Only SQL statements have been exported. It is initially believed that the backup damaged the file, re-use the SQL import, or report an error.

3. continue to think that the database is corrupted. Try check and repair and the result is erro.

4. Switch to the encoding problem, and the result code is the same.

5. Try to re-import the SQL. Check the SQL source file and find that many statements have problems.

6. Since it cannot be imported, direct import. The problem is solved.

Solution

Remote direct Database Import.

Tool navicat

1. Select a database and right-click data transmission.

2. Select the source and target, and click Start.

Summary

The above is all the content of this article. I hope the content of this article will help you in your study or work. If you have any questions, please leave a message. Thank you for your support.