Okay, I've hit a brick wall and have run out of ideas.
Master: 8.0.25-0ubuntu0.20.04.1
Slave: 5.7.33-0ubuntu0.16.04.1-log
Getting error with show slave status\G
:
Last_SQL_Errno: 22
Last_SQL_Error: Error 'Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file' on query. Default database: 'db'. Query: 'BEGIN'
I'm migrating my master server to a new host, which means that it's had lots of updates. The slave is the same previously used server and hasn't changed.
I've tried
reset slave all
& readdingchange master to
updating both master and slave my.cnf files to include:
[client] default-character-set=utf8
[mysqld] character-set-server=utf8 collation-server=utf8_unicode_c
manually updating the db collation on both to utf8
I'm out of ideas.