How to solve the mysql error 1033 Incorrect information in file: 'xxx.frm'

Problem Description

1. Database of the collection station

2. There is no problem with moving when there is no data, but after collecting data, some menus will report errors when moving.

Solution process

0. Various searches on Baidu and Google, but to no avail.

1. The original site database version is 5.0, and the new site database version is 4.2. I guess the versions are wrong, so I reinstalled the environment. invalid.

2. The backup provided by the customer is the source data under mysql/data, because Ye Yu did not do so when backing up. Only sql has been exported. I initially thought that the backup file was damaged, so I used SQL to import it again, but still got an error.

3. I continue to think that the database is damaged, and try to check and repair, but the result is still erro.

4. Turning to the coding problem, the result is the same.

5. Try to re-import sql, notice the error when importing, check the sql source file, and find that many statements have problems

6. Since exporting out and importing in doesn’t work, why not import directly? So, it was solved.

Workaround

Remote direct access to the database.

Tools Navicat

1. Select a database, right-click --- Data Transfer

2. Select the corresponding source and target and click Start

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.