Article ID: 114494, created on Aug 1, 2012, last review on May 11, 2014

  • Applies to:
  • Plesk 9.x for Windows


Trying to restore a MySQL backup to a newly created database:

Domains -> -> Backup Manager -> Database Backup Repository -> Upload Backup File -> select the "Restore database backup immediately upon uploading" checkbox -> OK

I get the following error:

Error: dbbackup failed: Unable to restore database 'testdb'
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 'PK' at line 1


Such error may occur if you are trying to restore a ZIP file instead of a valid MySQL dump.


Open the file you are trying to upload with notepad or other simple text editor and check if its contents are readable and resemble MySQL queries. If they are not, it means you either need to unpack the file first or find a different backup to restore.

We will soon adjust our documentation to make explicit references that database dumps are to be uploaded only in plain text.

aac4a8fcd879de03758354e15495d69a 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8

Email subscription for changes to this article
Save as PDF