mysqldump 报导常

 

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. 

 

mysqldump -uusername -h1xx.xx.1xx.xx -Pxxx6 -p  --set-gtid-purged=OFF --all-databases >all-databases01.sql
#增加--set-gtid-purged=OFF，问题解决