执行备份
#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