Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

getting error in mysql backup using mysqldump command

Tags:

mysql

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)

like image 216
sumit tripathi Avatar asked Jun 04 '26 18:06

sumit tripathi


1 Answers

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.

like image 168
Virendra Nagda Avatar answered Jun 06 '26 09:06

Virendra Nagda



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!