mysqldump 备份
$ mysqldump --login-path=d1 --all-databases > /data/all.sql 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.
正确的做法
root@feb.inno.com[09:35:36]:/data/mysql/d1 $ mysqldump --login-path=d1 --all-databases --triggers --routines --events > /data/all.sql