Error in your SQL syntax

  • nacnud99

    (@nacnud99)


    11 years, 8 months ago

    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/

Viewing 1 replies (of 1 total)
  • cagsmith

    (@cagsmith)

    11 years, 8 months ago

    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.