I am moving server from DigitalOcean due to poor service and support from them. I set up a new server at Hetzner. I exported our MySQL 8 database. It is in
prodsales.backup file. I installed MariaDB on my new server. But, I get strange problem and error. Not sure what to do. My command:
mysql prodsales < prodsales.backup
ERROR 1273 (HY000) at line 22: Unknown collation: 'utf8mb4_0900_ai_ci'
I thought MariaDB is drop-in replacement for MySQL. Anyway, how can I fix this?