Error running SQL file on MySQL

Back up the table data locally from the server, using the Navicat, right-click Table Dump SQL file, but always report an exception when you run the SQL file locally

[ERR] 1064-you has an error in your SQL syntax; Check the manual, corresponds to your MySQL server version for the right syntax to use near ****[err]/*

However, the SQL statements in the file can be run directly in the query.

On the Internet several methods can be used to restore data sharing:

1. Select the database connected to the server in the Navicat, select the tool in the menu bar and transfer data

2. export from backup. SQL and import into the local database

Finally, the problem is solved by restarting the service.

Error running SQL file on MySQL