数据库备份出现警告：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 thos
1.先来看原备份数据库语句：
1 mysqldump -h 127.0.0.1 -uroot -ppassword database > /usr/microStorage/dbbackup/capsule_prod$(date +%Y%m%d_%H%M%S).sql
警告信息1：
Warning: Using a password on the command line interface can be insecure.
意思是说：在命令行界面上使用密码可能是不安全的，不能直接把密码写在脚本中。
解决方法：
在/etc/my.cnf中配置用户名与密码
1 [client] 2 port = 3306 3 socket = /tmp/mysql.sock 4 default-character-set = utf8mb4 5 host = localhost //地址 6 user = root //用户 7 password = 'myServerPwd' //密码
现在备份数据库语句为：
1 mysqldump --defaults-extra-file=/etc/my.cnf database > /usr/microStorage/dbbackup/capsule_prod$(date +%Y%m%d_%H%M%S).sql
目前第一个警告解决。
警告信息2：
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.
关于GTID是5.6以后，加入了全局事务 ID (GTID) 来强化数据库的主备一致性，故障恢复，以及容错能力。
官方给的：A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (master).
解决方法：
在上面的脚本中加入 --set-gtid-purged=off 或者–gtid-mode=OFF这两个参数设置
现在备份数据库语句为：
1 mysqldump --defaults-extra-file=/etc/my.cnf --set-gtid-purged=off microstorage_backend > /usr/microStorage/dbbackup/capsule_prod$(date +%Y%m%d_%H%M%S).sql
以上两个警告解决。
