Backup database #1064 Error

  • Resolved ak0727

    (@ak0727)


    4 years, 10 months ago

    When I took a backup of the BackWPup plugin database and tried to import its sql file from phpMyAdmin, I got “Terminal quotes’. # 1064 –SQL syntax error”.

    This phenomenon does not occur when importing the sql file created by exporting phpMyAdmin.

    How should I solve it?

Viewing 8 replies - 1 through 8 (of 8 total)
  • happyAnt

    (@duongcuong96)

    4 years, 10 months ago

    Hello @ak0727
    Seems strange, which version of BackWPUp version you did the backup? also, could you please help me try backup with the latest version then try import the db again?
    Thank you!

    Thread Starter ak0727

    (@ak0727)

    4 years, 10 months ago

    Hello @duongcuong96

    Thank you for your reply.

    The plugin version is 3.6.10. I recognize it as the latest version.
    The database server is 10.1.48-MariaDB.

    Below are the BackWPup settings.
    -Database Backup type: SQL File
    -Backup file compression: none
    -Archive Format: Tar GZip
    -Backup file be stored: Backup to FTP

    Please let me know if you have any other necessary information.

    Best regards.

    happyAnt

    (@duongcuong96)

    4 years, 10 months ago

    Hello @ak0727
    Could you please help us try with this version, then test db backup with this?
    https://www.dropbox.com/s/6kkcfberab81cpt/backwpup-3.10.0-e3ac5e42.zip?dl=0
    Thank you so much!

    Thread Starter ak0727

    (@ak0727)

    4 years, 10 months ago

    Hello @duongcuong96

    I took a backup with the file you got and imported it into the database, but I got the same error.

    It is as follows.
    “There should be a terminating quote’.”
    “# 1064 –SQL syntax error”

    Thank you.

    Thread Starter ak0727

    (@ak0727)

    4 years, 10 months ago

    @duongcuong96

    When I opened the SQL file and checked it, it seemed that the SQL part was finished in the middle.

    Is there something like the number of lines that can be backed up in the settings?

    Thank you.

    happyAnt

    (@duongcuong96)

    4 years, 10 months ago

    @ak0727
    We never got this issue before, so it is really strange to me, also there is no line limit. How big is the SQL file btw?
    Also, the latest plugin version is 3.9 ^^.

    Thread Starter ak0727

    (@ak0727)

    4 years, 10 months ago

    Hello @duongcuong96

    Here, I found that it was a bug in the file decompression software.
    (When I used other decompression software, I was able to get the sql file without interrupting the file)

    We apologize for the inconvenience.
    thank you!

    happyAnt

    (@duongcuong96)

    4 years, 10 months ago

    @ak0727
    Happy to know we have a solution for that ^^
    In case you find BackWPUp is useful for you, we would really appreciate it if you leave a positive review and rating.
    This would encourage us to develop new free features and provide free support 😀
    https://ww.wp.xz.cn/support/plugin/backwpup/reviews/#new-post
    Thank you so much and have a great day!

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

The topic ‘Backup database #1064 Error’ is closed to new replies.