XF 2.2 1273 - Unknown collation: 'utf8mb4_0900_ai_ci

[Straydog]

Having some issues changing hosts. Files seem to have moved over properly but when restoring the DB I get the following;

CREATE TABLE `xf_tag_result_cache` (  `result_cache_id` int unsigned NOT NULL AUTO_INCREMENT,  `tag_id` int unsigned NOT NULL,  `user_id` int unsigned NOT NULL,  `cache_date` int unsigned NOT NULL,  `expiry_date` int unsigned NOT NULL,  `results` mediumblob NOT NULL,  PRIMARY KEY (`result_cache_id`),  UNIQUE KEY `tag_id_user_id` (`tag_id`,`user_id`),  KEY `expiration_date` (`expiry_date`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

I have searched and found the following topic here....

Migrating to MariaDB "ERROR 1273 (HY000) Unknown collation: 'utf8mb4_0900_ai_ci'"

Hi, I am attempting to migrating from MySQL 8.0.26 to the latest MariaDB. 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...

xenforo.com

Maybe I don't fully understand what I need to do or maybe I am missing something but what exactly should I do? Where should I looks for further information? I have checked the error logs but for some reason not seeing anything there. It is clear it is the hosting change. I am just hoping I can correct it and would appreciate anything anyone can provide. Worst case I can pull essential information from the original site but that would be a very slow process.