1、备份mysql数据库时候出错，导出数据：
[root@localhost ~]# mysqldump -uroot -p mysql >/root/bck.sql
Enter password:
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=': 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=' at line 1 (1064)
2、查询是否mysqldump版本问题：
[root@localhost ~]# mysqldump --version
mysqldump Ver 10.13 Distrib 5.1., for redhat-linux-gnu (x86_64)
[root@localhost ~]# which mysqldump
/usr/bin/mysqldump
3、用5.6.23版本的mysqldump覆盖或者指定目录运行即可
[root@localhost mysql]# cp /opt/mysql/mysql-5.6.-linux-glibc2.-x86_64/bin/mysqldump /usr/bin/mysqldump
cp: overwrite `/usr/bin/mysqldump'? y
4、查看是否备份成功：
[root@localhost mysql]# mysqldump -uroot -h127.0.0. -p test > /root/.sql
Enter password:
[root@localhost ~]# cat .sql
DROP TABLE IF EXISTS `SC`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SC` (
`Scid` int() NOT NULL AUTO_INCREMENT,
`Cno` int() NOT NULL,
`Sno` int() NOT NULL,
`Grade` tinyint() NOT NULL,
PRIMARY KEY (`Scid`)
.....................