Re: Replication Error Illegal Mix of Collations

[Rick James]

Thanks. You prodded me into figuring out the details. Here, all for you:

http://mysql.rjweb.org/doc.php/charcoll#fixing_mismatch_between_charset_and_data_encoding

A quick glance at the binlog dumps --
e4 shows up for a o-tilde, but that is the cp850 encoding, not the latin1 encoding, which MySQL thinks it is.

I suspect that fixing either the CHARSET or the encoding -- on both Master and Slave -- will solve the original problem of Duplicate key.

If you are happy with simply reloading the Slave (yet again), then fix the Master and do that.