问题:

如题

参考:

mysqldump 备份某张表 Warning: A partial dump from a server that has GTIDs

解决办法:

加–set-gtid-purged=off

mysqldump -uUsername -h xx.xx.xx.xx -P9996 DBname t_name --set-gtid-purged=off -p >t_name.sql(表名)