Skip to main content
Question

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

  • October 30, 2014
  • 3 replies
  • 4 views

Forum|alt.badge.img+1

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

3 replies

donmontalvo
Forum|alt.badge.img+36
  • Hall of Fame
  • October 30, 2014

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


Forum|alt.badge.img+9
  • Contributor
  • October 30, 2014

@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.


Forum|alt.badge.img+13
  • Contributor
  • October 31, 2014

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.