Archive for April 9th, 2013
Due to a bugs in mysqldump that ship with v5.5 & v5.6 neither are compatible with each others DB making backups across version impossible.
The first issue is that v5.5 mysqldump against a v5.6 server failes with: “
Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'” the second is that v5.6 mysqldump against a v5.5 server fails with “
Couldn't execute 'SELECT @@GTID_MODE': Unknown system variable 'GTID_MODE' (1193)”
There is however a dirty hack which works around this. Starting with mysqldump from v5.5 edit the binary and search for the test “
SET OPTION SQL_QUOTE_SHOW_CREATE” and replace each character in “
OPTION” with a space, so you end up with: “