Skip to main content
Question

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


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
  • Legendary Contributor
  • 4293 replies
  • October 30, 2014

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


Forum|alt.badge.img+9
  • Contributor
  • 116 replies
  • 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
  • 400 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings