Mysqldump: Couldnt execute SET OPTION SQL_QUOTE_SHOW_CREATE=1 mysql 5.6

Question

Here 2 similar questions, but they do not address the same exact issue, that I have:

Dump File MySQL 5.6.10

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

Answer 1

Try this

#vim mysqldump

find SET OPTION and replace the OPTION with 6 spaces