Title: SQL won't restore
Last modified: August 30, 2016

---

# SQL won't restore

 *  Resolved [trevorwood](https://wordpress.org/support/users/trevorwood/)
 * (@trevorwood)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/sql-wont-restore/)
 * I’m trying to restore the sql file created by my last backup to my test copy 
   of my website. I’m using the import function in phpMyAdmin and I’m getting the
   following error message
 * SQL query:
 * INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`,`
   post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `
   post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`,`
   post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`,`
   comment_count`) VALUES (4001, 1, ‘2015-05-31 17:57:52’, ‘2015-05-31 17:57:52’,‘
   Here\’s a great gotcha!\r\n\r\nI\’ve just upgraded my Windows test server to 
   run MySQL Community edition 5.6.25\r\n\r\nI have a script which runs daily to
   dump some of the database files from test website. The command used is MySQLDump
   and each dump is performed using a line of script something like this\r\n<p style
   =\”padding-left: 30px;\”>mysqldump -u username -ppassword database_table_name
   >dump_file_name.sql</p>\r\nWhen I ran the script manually I was surprised to 
   find it ran rather quickly, so I opened a command window and ran one of the lines
   manually\[…]
 * MySQL said: Documentation
    #1367 – Illegal double ‘63977e839585640’ value found
   during parsing
 * [https://wordpress.org/plugins/wordpress-backup-to-dropbox/](https://wordpress.org/plugins/wordpress-backup-to-dropbox/)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Michael De Wildt](https://wordpress.org/support/users/michaeldewildt/)
 * (@michaeldewildt)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/sql-wont-restore/#post-6402319)
 * Hi there,
 * I rarely check this forum so it’s best to email [support@wpb2d.com](https://wordpress.org/support/topic/sql-wont-restore/support@wpb2d.com?output_format=md)
   for timely support.
 * Have a wonderful weekend 🙂
 * Cheers,
    Mikey

Viewing 1 replies (of 1 total)

The topic ‘SQL won't restore’ is closed to new replies.

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

## Tags

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

 * 1 reply
 * 2 participants
 * Last reply from: [Michael De Wildt](https://wordpress.org/support/users/michaeldewildt/)
 * Last activity: [10 years, 10 months ago](https://wordpress.org/support/topic/sql-wont-restore/#post-6402319)
 * Status: resolved