Alibaba Cloud MySQL 8.0 to MySQL 5.6 error details

The blogger previously purchased Alibaba Cloud's cloud database, which is MySQL 8.0, but his own server is MySQL 5.6. Several errors were found in the import, so please record them today!

The first error: [ERR] 1214 - The used table type doesn't support FULLTEXT indexes. The reason for this error is that the InnoDB used in 8.0 does not support FULLTEXT indexes. It needs to be changed to MyISAM. Solution: Open the exported database file, edit and search InnoDB to replace MyISAM. The first error is fixed.

The second error: [ERR] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci', reason: MySQL 5.7 does not use this encoding format, but uses utf8_general_ci. Solution: Open the exported database file, edit and search utf8mb4_0900_ai_ci to replace utf8_general_ci. The second error is fixed.

The third error: [ERR] 1253 - COLLECTION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'. Solution: Open the exported database file, edit and search utf8mb4 to replace utf8. The third error can be repaired.

Tips: When some databases are exported, utf-8 is not selected, which causes problems in the post import data coding. At this time, the data table needs to be converted to utf-8 format. The details are shown in the screenshot below:

The error is repaired. After the code conversion is completed, the import is successful!

The above is the whole process of the blogger's conversion from MYSQL8.0 to MYSQL5.6. There may be more incompatibilities and other problems that I have not contacted. Let's try our best!