Following error occurs in backup file after a failed backup job.
-- Couldn’t execute ‘SELECT @@GTID_MODE’: Unknown system variable ‘GTID_MODE’ (1193) --
You got this message because MySQL Backup backup agent uses a newer version of mysqldump on your older version MySQL database , and your database server dose not support "GTIDs" .
GTIDs means Global Transaction Identifiers (GTIDs) , GTIDs make it simple to track and compare replication across a master-slave topology ,is introducted in MySQL 5.6 .
Since your server dose not support GTIDs , please add extra command "
--set-gtid-purged=OFF" in backup job settings window to disable this feature , as following :
You may also get a correct version of mysqldump.exe and place it to avoid this error