Here 2 similar questions, but they do not address the same exact issue, that I have:
https://dba.stackexchange.com/questions/42321/issue-on-mysqldump-in-mysql5-6
I have Debian 8 jessie (in a vmware as guest with win7 as host). I updated from mysql 5.5 to mysql 5.6 according to this link https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
Everything is working fine. I can successfully run this command from ssh agent(putty) - being connected to Debian from windows
mysqldump my_db > my_db.sql -uroot -p
dump file is being created, everything is perfect.
Now, I want to make the same thing from my win7 (so "remotely" connecting to debian's mysql). From win7 cmd I am trying to run
C:\Users\my_user>mysqldump my_db > my_db.sql -h192.168.252.178 -uroot -p
from which I am getting this error
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 MySQ L server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CR EATE=1' at line 1 (1064)
Please, note the following important things
1) In Debian both mysql server and mysql client have version 5.6
2) I can successfully run mysqldump from localhost (of Debian)
3) Mysql remote access is enabled
4) I can successfully connect "remotely" from win7 to debian8 by running mysql -h192.168.252.178 -uroot -p
5) This error appeared only after updating, before that it was working ok
How to solve this error to be able to run mysqldump from remote machine ?
Thanks
Try this
find SET OPTION and replace the OPTION with 6 spaces