i was getting the following error while taking database backup

[root@solr7 ~]# mysqldump -u root -p**** ostn>ostn

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

Post By Gishore J Kallarackal (2,121 Posts)

Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies can use for reference. You can follow me on the social web, subscribe to the RSS Feed or sign up for the email newsletter for your daily dose of tech tips & tutorials. You can content me via @twitter or e-mail.

Website: → Techgurulive