mysqldump问题

回复 收藏

写了一个自动备份mysql脚本,备份时候提示如下:

mysqldump: [Warning] Using a password on the command line interface can be insecure.

Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. 

脚本为111.png执行了脚本,也备份成功了,就是会出现上面的warning,然后根据提示,我在脚本里加了--set-gtid-purged=OFF.,因为是线上环境,没有测试,我在自己机子上测试的,提示mysqldump: unknown variable 'set-gtid-purged=off' ,有没有大神遇到过,告之一下。注:数据库版本为5.7,阿里云RDS

2017-08-10 11:34 举报
已邀请:

回复帖子,请先登录注册

退出全屏模式 全屏模式 回复
评分
可选评分理由: