You are here

Couldn’t execute ‘SELECT @@GTID_MODE’: Unknown system variable ‘GTID_MODE’ (1193)

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

{installation directory}\mysql

 

List of mysqldump

 

 

Download sql server ,mysql backup  restore software