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
@IanVaughan
Copy link

Many thanks, life saver!

@worldofchris
Copy link

Super Helpful! Many Thanks

@voleinikov
Copy link

Awesome thank you!

@CNG
Copy link

CNG commented Aug 5, 2013

Thanks :P

@chadothompson
Copy link

Lifesaver - thank you.

@papucho
Copy link

papucho commented Nov 21, 2013

Thanks! Right in the spot! :D

@dmarcoux
Copy link

Thank you!

@lovewangwei
Copy link

Thank you very much!

@scoates
Copy link

scoates commented Feb 19, 2014

👍

@poisa
Copy link

poisa commented Feb 20, 2014

👍

@kjantzer
Copy link

👍

@ExperimentMonty
Copy link

👍

@tellezhector
Copy link

(y)

@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