Title: Errors with restoring backups
Last modified: August 21, 2016

---

# Errors with restoring backups

 *  [avantiyoung](https://wordpress.org/support/users/avantiyoung/)
 * (@avantiyoung)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/errors-with-restoring-backups/)
 * Hello, I’ve had to move my blog to a new hosting provider but cannot seem to 
   import the database backup.
 * I get this error – can you please help?
 * There is a chance that you may have found a bug in the SQL parser. Please examine
   your query closely, and check that the quotes are correct and not mis-matched.
   Other possible failure causes may be that you are uploading a file with binary
   outside of a quoted text area. You can also try your query on the MySQL command
   line interface. The MySQL server error output below, if there is any, may also
   help you in diagnosing the problem. If you still have problems or if the parser
   fails where the command line interface succeeds, please reduce your SQL query
   input to the single query that causes problems, and submit a bug report with 
   the data chunk in the CUT section below:
    —-BEGIN CUT—- eNo1jbsKAjEURIXt7lfMB8Tg3bAI6cISVuHmYbJa2IlY2Gwn6N
   +bFZxyOGfGl5KKxcgYe4iPFowe zFTnVndE4VNPYjHoQRuzNayZzrUgVQU3+TgrXHwjw+2OkK5HEdfYHeXgLEyTBsqHvDIq1XXGaN5D
   nsvrTeLiZPFY6PdA3eafL+qdIHQ= —-END CUT—- —-BEGIN RAW—-
 * ERROR: C1 C2 LEN: 1 2 11
    STR:
 * MySQL: 5.5.33-31.1
    USR OS, AGENT, VER: Mac MOZILLA 5.0 PMA: 3.5.5 PHP VER,OS:
   5.3.17 Linux LANG: en SQL:
 * —-END RAW—-
 * SQL query:
 * MySQL said: Documentation
    #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 near ” at line 1

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/errors-with-restoring-backups/#post-4349382)
 * possibly related:
    [http://codex.wordpress.org/WordPress_Backups](http://codex.wordpress.org/WordPress_Backups)
   [http://codex.wordpress.org/Backing_Up_Your_Database](http://codex.wordpress.org/Backing_Up_Your_Database)
   [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup)
 *  Thread Starter [avantiyoung](https://wordpress.org/support/users/avantiyoung/)
 * (@avantiyoung)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/errors-with-restoring-backups/#post-4349452)
 * Thanks those were the instructions I originally followed but I still get the 
   error message. I’m not sure if its an issue with the version of phpmyadmin?
 * The old server had this version:
    Version information: 4.0.5, latest stable version:
   4.0.9
 * The new server has this:
    Version information: 3.5.5, latest stable version: 
   4.0.9
 * Also the old web server is cpsrvd 11.38.2.12
    The new web server is cpsrvd 11.36.2.9
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/errors-with-restoring-backups/#post-4349455)
 * I dont’t know the difference between the different versions you listed in your
   reply. May be someone who knows the difference can chime in.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Errors with restoring backups’ is closed to new replies.

## Tags

 * [backups](https://wordpress.org/support/topic-tag/backups/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [t-p](https://wordpress.org/support/users/t-p/)
 * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/errors-with-restoring-backups/#post-4349455)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics