MySQL error in SQL syntax: Couldn't execute "SET OPTION SQL_QUOTE_SHOW_CREATE=1"

[seannot]

My JSS backup is reporting an error: Couldn't execute "SET OPTION SQL_QUOTE_SHOW_CREATE=1
MySQL version 5.6.21 64bit
Can someone help with this
Thanks

[donmontalvo]

MySQL 5.6.x <-- kinda blows chunks, we've stuck with 5.5

[GaToRAiD]

@seannot try to manually run the backup via the JSSDatabaseUtility. When you run it on a schedule it only does an optimize of the database. When you run it via the Utility, it will run a repair and optimize. Try this and see if it fixes the issue. If not you might want to call your rep with JSS since you could be having bigger issues with your database.

[Kumarasinghe]

It seems you are trying to backup 5.6.x database using a previous version of mysqldump.
Please upgrade your MySQL to 5.6.x (specifically mysqldump) in the JSS server where you take backups.