I want to take backup for 3308 port in mysql using below given mysqldump command ,but I am getting this error.plz help.
mysqldump -h 172.16.150.10 -P 3308 -uroot -proot rt_CallAnalysis > b.sql
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 MySQL server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)
The reason for this is that MySQL 5.6 has removed support for “SET OPTION” and your mysql client tools are probably on older version.
you just see this link more detail.meet your answer.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With