[root@zabbix-bak ~]# mysqldump -ubackup -p --opt -R --all-databases>/tmp/mysqldump/all_databases-2016-10-11.sql
Enter password:
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，环境变量设置的另外一个版本的路劲
[root@zabbix-bak ~]# ps -ef|grep mysql|grep -v grep
mysql 20578 20362 6 Sep22 ? 1-07:03:42 /usr/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr 。。。。。。
[root@zabbix-bak ~]#
[root@zabbix-bak ~]# time /usr/bin/mysqldump -uadmin -p --opt -R --all-databases>/root/mysqldump/all_databases-2016-10-11-135.sql
Enter password:
real 1m15.074s
user 0m36.139s
sys 0m3.554s
阅读(1285) | 评论(0) | 转发(0) |
