Mysqldump back up a table warning:a partial dump from a server, which has gtids would by default include the Gtids of all transactions ,

[Email protected] ok]# mysqldump-uemove-h xx.xx.xx.xx-p9906 DBname t_name-p >2t_tname.sql


Pass--set-gtid-purged=off. To make a complete dump, pass--all-databases--triggers--routines--events.

 [[email protected] desktop]# mysqldump--versionmysqldump Ver  10.13  distrib 5.6 . 34 , for   After Linux (x86_64) about GTID is 5.6, a global transaction ID (GTID) has been added to harden the database's primary and standby consistency, fault recovery, and fault tolerance. Official: A  global  transaction identifier (GTID) is   a unique identifier created and associated with each transaction committed on the server of Origin (master). So it may be because it is unique within a database, but it can be duplicated when importing other libraries. All will have a reminder. You can add --set -gtid-purged=off or –gtid-mode= off these two parameter settings. Personally, the Gtid is re-produced in the import library instead of the original. 

[Email protected] ok]# mysqldump-uusername-h xx.xx.xx.xx-p9996 DBname t_name--set-gtid-purged=off-p >t_n Ame.sql (table name)

Mysqldump back up a table warning:a partial dump from a server, which has gtids would by default include the Gtids of all transactions ,