Zabbix ERROR 1273 (HY000) at line 483: Unknown collation: ‘utf8mb4_0900_ai_ci’

One day I was migrating a Zabbix server database to another server and an error occurred:

mysql -D zabbix < zabbix_no_history_2024-01-25.sql
ERROR 1273 (HY000) at line 483: Unknown collation: 'utf8mb4_0900_ai_ci'

MySQL was installed on the old server, and on the new server the newest version of MariaDB, which did not support this encoding, so I changed it by auto-correcting in the sql file to utf8mb4_unicode_ci via notepad++ since the dump had no history and did not take up very much memory.

Can also be changed using sed:

sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' DB.sql

After this, the sql dump was successfully imported into an empty database:

See also my article:
Zabbix Backup

Leave a comment

Leave a Reply