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