Title: Cannot complete full backup
Last modified: August 24, 2016

---

# Cannot complete full backup

 *  Resolved [Benmjt](https://wordpress.org/support/users/benmjt/)
 * (@benmjt)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/cannot-complete-full-backup/)
 * With the past few releases I haven’t been able to complete a full backup. I hoped
   the latest update would fix this, but still getting the following error message:
 * > mysqldump: Couldn’t execute ‘SET OPTION SQL_QUOTE_SHOW_CREATE=1’: 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 ‘OPTION SQL_QUOTE_SHOW_CREATE
   > =1’ at line 1 (1064)
 * Any help or advice would be appreciated.
 * Thanks.
 * [https://wordpress.org/plugins/backupwordpress/](https://wordpress.org/plugins/backupwordpress/)

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

 *  Plugin Author [cuvelier](https://wordpress.org/support/users/cuvelier/)
 * (@cuvelier)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/cannot-complete-full-backup/#post-6092133)
 * Hi there,
 * Thanks for getting in touch.
 * To resolve the error you’ll need to contact your host and ask them to update 
   the MYSQL Client Tools to version 5.6 or later.
 * Source: [http://www.markomedia.com.au/mysqldump-mysql-5-6-problem-solved/](http://www.markomedia.com.au/mysqldump-mysql-5-6-problem-solved/)
 * Let me know how you get on,
 * Cheers!
    Owain
 *  Thread Starter [Benmjt](https://wordpress.org/support/users/benmjt/)
 * (@benmjt)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/cannot-complete-full-backup/#post-6092134)
 * That’s great Owain, i’ll get in touch with them now.
 * Thanks!

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

The topic ‘Cannot complete full backup’ is closed to new replies.

 * ![](https://ps.w.org/backupwordpress/assets/icon-256x256.jpg?rev=1105225)
 * [BackUpWordPress](https://wordpress.org/plugins/backupwordpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backupwordpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backupwordpress/)
 * [Active Topics](https://wordpress.org/support/plugin/backupwordpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backupwordpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backupwordpress/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Benmjt](https://wordpress.org/support/users/benmjt/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/cannot-complete-full-backup/#post-6092134)
 * Status: resolved