Skip to content

Instantly share code, notes, and snippets.

@arun057
Created May 10, 2013 18:53
Show Gist options
  • Save arun057/5556563 to your computer and use it in GitHub Desktop.
Save arun057/5556563 to your computer and use it in GitHub Desktop.
mysqldump: Couldn’t execute ‘SELECT @@GTID_MODE’: Unknown system variable ‘GTID_MODE’ (1193)
# If you are using the MySQL 5.6 version of mysqldump on an older MySQL database, you might get the error message.
mysqldump: Couldn't execute 'SELECT @@GTID_MODE': Unknown system variable 'GTID_MODE' (1193)
# This error is in part due to the introduction of Global Transaction Identifiers (GTIDs) in MySQL 5.6. GTIDs make it simple to # track and compare replication across a master-slave topology.
# mysqldump tries to query this system variable, which doesn’t exist in earlier versions, and then fails. The solution is to add # –set-gtid-purged=OFF in the mysqldump command. It should look something like
mysqldump -h dbHost -u dbuser dbName --set-gtid-purged=OFF
# http://blog.teamextension.com/mysqldump-couldnt-execute-select-gtid_mode-unknown-system-variable-gtid_mode-1193-1246
@pedro3102
Copy link

thanks man!!!

@blueeep
Copy link

blueeep commented Mar 20, 2019

it works and thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment