Problem Dumping MySQL Database - Unknown System Variable 'GTID_MODE'
I was trying to dump and restore a MySQL database today, but received the following error when I tried to dump:
The MySQL version of the database I was trying to dump was 5.5.28 and the server I was trying to restore into was 5.6.10.
A quick google told me that the error was likely due to this mismatch in versions. From the teamextension blog:
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.
The solution is adding the following option to your dump statement:
In all, my statement was: