MySQL ERROR 1273 (HY000) at line 217: Unknown collation: ‘utf8mb4_0900_ai_ci’

This morning i got error notification when try to importing database from the old server to the new server. I use MySQL for the old server and choose to use MariaDB in new server

To solve this problem you only need to change utf8mb4_0900_ai_ci to utf8mb4_unicode_ci

You can just run one line of code to solve this problem

sed -e ‘s/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g’ -i file.sql

After do that, you can impor the MySQL database to MariaDB without any problem.

Thank you stackexchange & panduaji! It’s help me solve problem in new server