I did upgrade the MySQL server from 5.5
to 5.6
I am trying to take dump for a table like this
mysqldump -uroot -p dba admin > D:\admin.sql
But it gets following error
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1':
You have an er ror in your SQL syntax; check the manual that
corresponds to your MySQL server v ersion for the right syntax to use
near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)
edit:
mysqldump verison is 5.5.30.
Best Answer
Some information can be found in SET Syntax and this bug.
How to fix it
If the problem happens when you are creating the dump (your case): Upgrade you MySQL client tools to the same version of your MySQL server (in your case, 5.6)
If the problem happens when you are restoring the dump: At the beginning of the file, you have some
SET OPTION
statements; edit your dump, and change all instances ofSET OPTION
toSET SESSION
like described here