mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'

执行备份

#mysqldump -uroot -pgsm_wldb --single-transaction --flush-logs --master-data=2 -B mtms800 > /bkmysql/mtms800.20151012

报错

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)

原来系统有自带的mysql和二进制安装的mysql，且版本不同，在执行mysql相关命令时，首先找到自带mysql命令

<pre name="code" class="sql"># which mysqldump
/usr/bin/mysqldump
# mysqldump --version
mysqldump  Ver 10.13 Distrib 5.1.66, for redhat-linux-gnu (x86_64)
/home/mysql/product/5.6/bin/mysqldump --version
mysqldump  Ver 10.13 Distrib 5.6.17, for linux-glibc2.5 (x86_64)

可以添加绝对路径解决

# /home/mysql/product/5.6/bin/mysqldump -uroot -pgsm_wldb --single-transaction --flush-logs --master-data=2 -B mtms800  > /bkmysql/mtms800.20151012

或者将需要的目录放到PATH前面

# export PATH=$BASEDIR/bin:$PATH
# which mysqldump
/home/mysql/product/5.6/bin/mysqldump