Title: Cannot backup my .sql file in phpmyadmin (Syntax Error)
Last modified: August 21, 2016

---

# Cannot backup my .sql file in phpmyadmin (Syntax Error)

 *  Resolved [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * (@oreocrumble)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/)
 * When I try importing my .sql file I get this error:
 * > Error
   >  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 ’16:01:00, ‘1381960387’,‘
   > individual’, ‘public’, ‘edwin-figueroa’, ”, ‘Dr.’, ‘Ed’ at line 1
 * Anyone help?
    Compatibility Mode: None
 * [http://wordpress.org/plugins/backupwordpress/](http://wordpress.org/plugins/backupwordpress/)

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

 *  Plugin Contributor [Paul de Wouters](https://wordpress.org/support/users/pauldewouters/)
 * (@pauldewouters)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396234)
 * Hello
 * Are you trying to import an sql file from a BackUpWordPress backup?
 * Are you using the WPML plugin?
 *  Thread Starter [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * (@oreocrumble)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396321)
 * Yes, I am using BackUpWordpress plugin and trying to import sql file in phpmyadmin
 *  Thread Starter [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * (@oreocrumble)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396322)
 * and trying to import via phpmyadmin
 *  Plugin Contributor [Paul de Wouters](https://wordpress.org/support/users/pauldewouters/)
 * (@pauldewouters)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396428)
 * What other plugins do you have installed?
 *  Thread Starter [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * (@oreocrumble)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396432)
 * Please I need help with this import error. Site has been down for too long.
 * Other plugins I had:
 * ContactForm7
    GoogleAnalytics BetterWPSecurity CMSTreePageView W3TotalCache TinyMCEAdvanced
   ML-SliderPro Connections GoogleTranslator
 *  Plugin Author [Tom Willmot](https://wordpress.org/support/users/willmot/)
 * (@willmot)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396433)
 * Could you possible email me the offending SQL file.
 * I’d imagine this is related to [https://github.com/humanmade/hm-backup/pull/34](https://github.com/humanmade/hm-backup/pull/34)
   but we thought we had that fixed.
 *  Thread Starter [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * (@oreocrumble)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396434)
 * Sure, I will email to tom [at] hmn [dot] md
 * I appreciate your insight and help with this issue.
 *  Plugin Author [Tom Willmot](https://wordpress.org/support/users/willmot/)
 * (@willmot)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396435)
 * I was able to fix the database using regex, the issue is that timestamps weren’t
   properly encoded, this was fixed in [https://github.com/humanmade/hm-backup/pull/34](https://github.com/humanmade/hm-backup/pull/34)
   so this backup must have been from an old version of the plugin.
 * I verified that creating a backup of that database with the latest version of
   the plugin created a valid sql file.
 *  Thread Starter [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * (@oreocrumble)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396436)
 * Tom,
 * It worked perfectly!
    Thank you for help and support on this item.
 * I hope this serves as reference to anyone else that has the same issue.

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

The topic ‘Cannot backup my .sql file in phpmyadmin (Syntax Error)’ is closed to
new replies.

 * ![](https://ps.w.org/backupwordpress/assets/icon-256x256.jpg?rev=1105225)
 * [BackUpWordPress](https://wordpress.org/plugins/backupwordpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backupwordpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backupwordpress/)
 * [Active Topics](https://wordpress.org/support/plugin/backupwordpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backupwordpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backupwordpress/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 9 replies
 * 3 participants
 * Last reply from: [oreocrumble](https://wordpress.org/support/users/oreocrumble/)
 * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/cannot-backup-my-sql-file-in-phpmyadmin-syntax-error/#post-4396436)
 * Status: resolved