问题1:MySql Workbench 备份数据库时,报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.
解决方法: 1、在Data Export处点击【Advanced Options】按钮,SET@@GLOBAL.GTID_PURGED=OFF;
2、导入数据时正常导入,不会报ERROR 3546 (HY000) at line 24: @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED;