Making mysqldump v5.5 work with v5.6 servers
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: “SET SQL_QUOTE_SHOW_CREATE
“
Leave a Reply
You must be logged in to post a comment.