mysqldump:mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual t13.mysqldump:mysql

  1. 云栖社区>
  2. 袋鼠云技术团队>
  3. 博客>
  4. 正文

mysqldump:mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual t13.mysqldump:mysql

王静静@ 2016-10-22 16:07:07 浏览4587
展开阅读全文

1、备份mysql数据库时候出错,导出数据:

[root@localhost ~]# mysqldump -uroot -p mysql >/root/bck.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)
2、查询是否mysqldump版本问题:

[root@localhost ~]# mysqldump --version
mysqldump Ver 10.13 Distrib 5.1.71, 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.23-linux-glibc2.5-x86_64/bin/mysqldump /usr/bin/mysqldump
cp: overwrite `/usr/bin/mysqldump'? y
4、查看是否备份成功:

[root@localhost mysql]# mysqldump -uroot -h127.0.0.1 -p test > /root/1.sql
Enter password:
[root@localhost ~]# cat 1.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(12) NOT NULL AUTO_INCREMENT,
Cno int(10) NOT NULL,
Sno int(10) NOT NULL,
Grade tinyint(2) NOT NULL,
PRIMARY KEY (Scid)
.....................

网友评论

登录后评论
0/500
评论
王静静@
+ 关注
所属团队号: 袋鼠云技术团队