Title: Backup database #1064 Error
Last modified: July 21, 2021

---

# Backup database #1064 Error

 *  Resolved [ak0727](https://wordpress.org/support/users/ak0727/)
 * (@ak0727)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/)
 * 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](https://wordpress.org/support/users/duongcuong96/)
 * (@duongcuong96)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14684878)
 * Hello [@ak0727](https://wordpress.org/support/users/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](https://wordpress.org/support/users/ak0727/)
 * (@ak0727)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14699818)
 * Hello [@duongcuong96](https://wordpress.org/support/users/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](https://wordpress.org/support/users/duongcuong96/)
 * (@duongcuong96)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14702843)
 * Hello [@ak0727](https://wordpress.org/support/users/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](https://www.dropbox.com/s/6kkcfberab81cpt/backwpup-3.10.0-e3ac5e42.zip?dl=0)
   Thank you so much!
 *  Thread Starter [ak0727](https://wordpress.org/support/users/ak0727/)
 * (@ak0727)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14704404)
 * Hello [@duongcuong96](https://wordpress.org/support/users/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](https://wordpress.org/support/users/ak0727/)
 * (@ak0727)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14704577)
 * [@duongcuong96](https://wordpress.org/support/users/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](https://wordpress.org/support/users/duongcuong96/)
 * (@duongcuong96)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14707063)
 * [@ak0727](https://wordpress.org/support/users/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](https://wordpress.org/support/users/ak0727/)
 * (@ak0727)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14709622)
 * Hello [@duongcuong96](https://wordpress.org/support/users/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](https://wordpress.org/support/users/duongcuong96/)
 * (@duongcuong96)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14710309)
 * [@ak0727](https://wordpress.org/support/users/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://wordpress.org/support/plugin/backwpup/reviews/#new-post](https://wordpress.org/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.

 * ![](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/)

 * 8 replies
 * 2 participants
 * Last reply from: [happyAnt](https://wordpress.org/support/users/duongcuong96/)
 * Last activity: [4 years, 10 months ago](https://wordpress.org/support/topic/backup-database-1064-error/#post-14710309)
 * Status: resolved