Database restore / import error#1065

  • 2bearstudio

    (@2bearstudio)


    13 years, 3 months ago

    Error
    SQL query:

    medallion.sql010064400000410000041000575443651212276136200136730ustar00www-datawww-data– ——————————————————— — Dumped with BackWPup ver.: 3.0.6 — https://marketpress.de/product/backwpup-pro/ — Blog Name: xxxxxxxxxxxxxx — Blog URL: 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/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter 2bearstudio

    (@2bearstudio)

    13 years, 3 months ago

    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/
    — Blog Name: xxxxxxxxxxxxxx
    — Blog URL: 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

    (@danielhuesken)

    13 years, 2 months ago

    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.