2
  • Master (mysql Ver 8.0.16)
  • Slave (mysql Ver 15.1 Distrib 10.3.15-MariaDB)

I have this 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: 'test.database'. Query: 'BEGIN'

    MASTER my.cnf
    [mysqld]
    collation-server = utf8_unicode_ci
    character-set-server = utf8
    [client]
    default-character-set=utf8

    SLAVE my.cnf
    [client]
    default-character-set=utf8mb4
    [mysql]
    default-character-set=utf8mb4
    [mysqld]
    character-set-server = utf8mb4

1 Answer 1

1

The Master should not be a newer version than the Slave(s). In this case, 8.0 has a lot of new collations that do not exist in 5.7. And the defaults pull you toward them.

Plan A: Change the collations in the Master.
Plan B: Upgrade the Slave to 8.0.

Meanwhile, suggest filing a bug at bugs.mysql.com pointing out how awkward it is to upgrade a Master-Slave setup with 8.0 calling for a collation that does not exist in 5.7.

1
  • 1
    finally i setup mysql 8 and all problems solved. Commented Jun 8, 2019 at 7:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.