mydump 备份数据库

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