Skip to content

Instantly share code, notes, and snippets.

View chadothompson's full-sized avatar
🚜
Tinkering. Probably should be sleeping.

Chad Thompson chadothompson

🚜
Tinkering. Probably should be sleeping.
View GitHub Profile
@ryanycoleman
ryanycoleman / links
Last active March 28, 2018 17:44
links from 2014 puppetconf contributor summit lightning talks
@arun057
arun057 / gist:5556563
Created May 10, 2013 18:53
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