Title: Error in your SQL syntax
Last modified: August 22, 2016

---

# Error in your SQL syntax

 *  [nacnud99](https://wordpress.org/support/users/nacnud99/)
 * (@nacnud99)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/error-in-your-sql-syntax-2-2/)
 * I was trying to clone a WP site and tried to upload to the newly created database
   in phpMyAdmin a zipped database downloaded with BackWPup in Tar Gzip format, 
   However it failed, I got the message #1064 – You have an error in your SQL syntax;
   check the manual that corresponds to your MySQL server version for the right 
   syntax to use. Also, something about an “OLD CHARACTER SET: check the manual”.
 * I have now succeeded by exporting the database of the clone-original from phpMyAdmin
   instead, and importing it again into the new database.
 * However, it concerns me the BackWPUp database didn’t work, in case I should ever
   need to do this in case of site failure etc. What caused this and how can I correct
   it?
 * [https://wordpress.org/plugins/backwpup/](https://wordpress.org/plugins/backwpup/)

Viewing 1 replies (of 1 total)

 *  [cagsmith](https://wordpress.org/support/users/cagsmith/)
 * (@cagsmith)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/error-in-your-sql-syntax-2-2/#post-5504831)
 * Did you try opening up the raw SQL file in a decent text editor like Notepad+
   + to check it looks ok?
 * Also, if you’re importing a DB in via PhpMyAdmin then you can’t import the (g)
   zipped tarball – you need to inflate archive first and extract just the .sql (
   or .sql.gz) file. BackWPup includes a readme and manifest file in the completed
   archive. Trying to import the untouched completed archive will result in an error
   since PhpMyAdmin doesn’t know what to do with the other files in the archive.

Viewing 1 replies (of 1 total)

The topic ‘Error in your SQL syntax’ is closed to new replies.

 * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141)
 * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backwpup/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backwpup/)
 * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [cagsmith](https://wordpress.org/support/users/cagsmith/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/error-in-your-sql-syntax-2-2/#post-5504831)
 * Status: not resolved