Applicable to:
- Plesk for Windows
Symptoms
Importing a dump in Plesk > Domains > example.com > Databases > database_name > Import Dump fails with the following error:
PLESK_ERROR: Unable to import the database_name dump:
Unable to restore database 'database_name'
ERROR 1050 (42S01) at line 29: Table 'table_name' already exists
(Error code 22)
OR
PLESK_ERROR: ERROR 1064 (42000) at line 3678: 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 '------WebKitFormBoundaryKlp0WRjldBLt0a4h
Content-Disposition: form-data' at line 1
(Error code 22)
The dump was created with the following end-line:
CONFIG_TEXT: ------WebKitFormBoundaryKlp0WRjldBLt0a4h
Content-Disposition: form-data; name="overwrite"
0
Cause
Database dump was created using a non-standard tool and has non-standard structure.
Resolution
-
Open the dump file with any text editor and remove the following line:
CONFIG_TEXT: ------WebKitFormBoundaryKlp0WRjldBLt0a4h
Content-Disposition: form-data; name="overwrite"
0 - Login to Plesk
-
Re-import the dump at Plesk > Domains > example.com > Databases > database_name > Import Dump
Additional information
Cannot restore MySQL dump: You have an error in your SQL syntax
Comments
0 comments
Please sign in to leave a comment.