Title: Database restore / import error#1065
Last modified: August 20, 2016

---

# Database restore / import error#1065

 *  [2bearstudio](https://wordpress.org/support/users/2bearstudio/)
 * (@2bearstudio)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/database-restore-import-error1065/)
 * Error
    SQL query:
 * medallion.sql010064400000410000041000575443651212276136200136730ustar00www-datawww-
   data– ——————————————————— — Dumped with BackWPup ver.: 3.0.6 — [https://marketpress.de/product/backwpup-pro/](https://marketpress.de/product/backwpup-pro/)—
   Blog Name: xxxxxxxxxxxxxx — Blog URL: [http://xxxxxxxxxxxxxx/](http://xxxxxxxxxxxxxx/)—
   Blog ABSPATH: /home/xxxxxxxxxxxxxx/ — Blog Charset: UTF-8 — Table Prefix: wp_—
   Database Name: xxxxxxxxxxxxxx — Dumped on: 2013-03-21 21:49.52 — ———————————————————/*!
   40101 SET @OLD_CHARACTER_SET_CLIENT=@[…]
 * MySQL said:
 * #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 ‘xxxxxxxxxxxxxx.
   sql’ at line 1
 * [http://wordpress.org/extend/plugins/backwpup/](http://wordpress.org/extend/plugins/backwpup/)

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

 *  Thread Starter [2bearstudio](https://wordpress.org/support/users/2bearstudio/)
 * (@2bearstudio)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/database-restore-import-error1065/#post-3587602)
 * Manually Fix this problem by removing the first few lines from Database backup,
   like the following.
 * Is this a bug? Because this happened on all my database backup.
 * — ———————————————————
    — Dumped with BackWPup ver.: 3.0.6 — [https://marketpress.de/product/backwpup-pro/](https://marketpress.de/product/backwpup-pro/)—
   Blog Name: xxxxxxxxxxxxxx — Blog URL: [http://xxxxxxxxxxxxxx](http://xxxxxxxxxxxxxx)—
   Blog ABSPATH: /home/xxxxxxxxxxxxxx/ — Blog Charset: UTF-8 — Table Prefix: wp_—
   Database Name: xxxxxxxxxxxxxx — Dumped on: 2013-03-21 21:49.52 — ———————————————————
 *  Plugin Contributor [Daniel Hüsken](https://wordpress.org/support/users/danielhuesken/)
 * (@danielhuesken)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/database-restore-import-error1065/#post-3587845)
 * That looks like that the file not correctly extracted from the tar archive. Because
   the tar header is in line 1.

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

The topic ‘Database restore / import error#1065’ is closed to new replies.

 * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141)
 * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/)
 * [Support Threads](https://wordpress.org/support/plugin/backwpup/)
 * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Daniel Hüsken](https://wordpress.org/support/users/danielhuesken/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/database-restore-import-error1065/#post-3587845)
 * Status: not resolved