Issues encountered during MySQL migration

In the process of migrating a Web site, an error occurred while importing the phpMyAdmin exported database again using Navicat to another database

The error prompt is #1064-you have an error in your SQL syntax; ...

The first analysis is a syntax error in the error prompt, the syntax error is imported into the table to find no errors

The second analysis is that the database table is beyond the string atmosphere after the modified test discovery is still not the cause of the error

The third time to re-use the phpMyAdmin Export data discovery and low-sequentially exported database size discrepancies the next third export found that three export file sizes are different

The preliminary decision is that the database is not exported completely

After you use the command on the database server mysqldump-u user-p databasename > Name.sql

The exported data is found to be much larger than the first three exported data.

Import a database test again using NAVICAT after export or use the command line import

This article is from the "Forsk" blog, make sure to keep this source http://forsk.blog.51cto.com/8096006/1547352

Problems encountered during the MySQL migration