[RSS Feed/News] Migrating to MariaDB "ERROR 1273 (HY000) Unknown collation: 'utf8mb4_0900_ai_ci'"

[XenForo]

Hi,

I am attempting to migrating from MySQL 8.0.26 to the latest MariaDB.

1. I dump my database with "mysqldump --no-tablespaces --default-character-set=utf8" or "mysqldump --no-tablespaces --default-character-set=utf8mb4", this doesn't seem to make a difference. In the past I've dumped and restored without any issues from MySQL to MySQL.
2. Now, when I import my database into MariaDB, it throws an error "ERROR 1273 (HY000) Unknown collation: 'utf8mb4_0900_ai_ci"

My board is...

Read more

ادامه مطلب...