Cannot restore MySQL dump: You have an error in your SQL syntax

Created:

2017-08-11 16:58:16 UTC

Modified:

2017-08-16 17:39:13 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot restore MySQL dump: You have an error in your SQL syntax

Applicable to:

  • Plesk for Windows

Symptoms

Cannot restore MySQL dump:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ■-

Cause

Wrong MySQL dump encoding.

Resolution

1. Open the dump in Notepad++ and change encoding to UTF8 (without BOM):

dump1.png

2. Save the converted dump

Have more questions? Submit a request
Please sign in to leave a comment.