Title: Syntax Error on restore
Last modified: August 22, 2016

---

# Syntax Error on restore

 *  Resolved [dwpoyner](https://wordpress.org/support/users/dwpoyner/)
 * (@dwpoyner)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-on-restore/)
 * I am having a problem on restoring my DB backup. For instance, this is a line
   I’m having an issue with:
 * `INSERT INTO wp_links VALUES(8, http://LINK.com, NAME, NULL, _blank, NULL, Y,
   2, 1, 0000-00-00 00:00:00, me, NULL, NULL);`
 * When I put a `'` around each of those values, it imports fine. At this rate, 
   I can redo my entire site if I have to manually change each of these. Any suggestions
   on how to make this work properly?
 * [https://wordpress.org/plugins/backup-scheduler/](https://wordpress.org/plugins/backup-scheduler/)

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

 *  Plugin Author [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-on-restore/#post-5725743)
 * Normally, the quote should be present around only strings / dates
 * If there are not present it is probable that you have a strange SQL engine ? 
   what is your SQL engine ?
 * If you want, I may add with a script the missing quotes ?
 * If you want so, please contact me through the feedback tab and then I will give
   you the process to follow to send me the SQL files
 *  Thread Starter [dwpoyner](https://wordpress.org/support/users/dwpoyner/)
 * (@dwpoyner)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-on-restore/#post-5725770)
 * For whatever reason, I cannot import the files through the import function in
   phpmyadmin. It gives me a failure on the first line. I’m using MySQL 5.1. If 
   I go through and and single quotes around each string, it runs fine. You can 
   see the [screenshot of the failure here](https://dl.dropboxusercontent.com/u/1435970/2015-01-29%2008.38.39%20am1.png).
 * As soon as I add the quotes, it runs fine. I’ll have to contact you here right
   now because my site is toast. Let me know if there is a better way to get these
   files to you. I did this manually all day yesterday and didn’t make it through
   the first of 7 backup SQL files.
 *  Thread Starter [dwpoyner](https://wordpress.org/support/users/dwpoyner/)
 * (@dwpoyner)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-on-restore/#post-5725773)
 * And yes, any help you can offer is much appreciated. At this rate it will take
   me two weeks to get through all of these files. Let me know where to send them,
   and I will get them to you right now.
 *  Plugin Author [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-on-restore/#post-5725780)
 * send me the files at myname @ myname .fr (assuming that myname is sedlex)

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

The topic ‘Syntax Error on restore’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/backup-scheduler_f8f7f7.svg)
 * [Backup Scheduler](https://wordpress.org/plugins/backup-scheduler/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backup-scheduler/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backup-scheduler/)
 * [Active Topics](https://wordpress.org/support/plugin/backup-scheduler/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backup-scheduler/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backup-scheduler/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-on-restore/#post-5725780)
 * Status: resolved