Solve the problem of "ERROR 1214 (HY000)\\" when importing MySQL database

Today, when Snail was importing the database during the data migration process of a project, an error message like "ERROR 1214 (HY000) at line 343639: The used table type doesn\\'t support FULLTEXT indexes\\" appeared. I asked my colleague where he had uploaded the database from, and was told that the customer packaged it directly from another company. I didn’t know exactly what environment it was in and what database version it was.

Then use a universal search to see if there is a similar solution. It probably means that the database version and encoding are different, resulting in some data tables not being imported and incomplete. InnoDB in the database needs to be replaced by MyISAM.

If it is a little troublesome to change the MYSQL version, fortunately the database.SQL file is not very large, so just open the data table directly, and then replace all InnoDB with MyISAM characters. Then import it again, so there is no report.

Recommended site searches: logout registration, godaddy space, asp website space, domain name registration information query, domain name check, ws domain name, Korean independent server, personal registered domain name, server rental, China Unicom virtual host,