Mysql error 1033 Incorrect information in file: ''''xxx.frm'''' solution (picture)

This article mainly introduces the solution to the mysql error 1033 Incorrect information in file: 'xxx.frm' problem. The article introduces it in detail through sample code. Friends in need can refer to it. Let’s take a look below.

Problem Description

1. The database of the collection station

2. There is no problem in moving when there is no data. After collecting the data and moving, some menus reported errors

Solution process

0. All kinds of Du Niang, Gu Ge, to no avail.

1. The original site database version is 5.0, and the new home database version is 4.2. I guess the version is wrong, so 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 has been exported. It was initially thought that the backup had damaged the file, so I tried importing it using SQL again, but still got an error.

3. Continue to think that the database is damaged, try check and repair, but the result is still error.

4. Turned to the encoding issue, the result is the same encoding.

5. Try to re-import sql and notice the error when importing. Check the sql source file and find that there are problems with many statements

6. Since exporting and importing cannot work, how about direct importing? So, it was solved.

Solution

Direct database remote guidance.

Tool navicat

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

2. Select the corresponding source and target , click start

Summary

The above is the detailed content of Mysql error 1033 Incorrect information in file: ''''xxx.frm'''' solution (picture). For more information, please follow other related articles on the PHP Chinese website!