Hello,
I am migrating a Joomla site using Akeeba Backup from the following source server:
Server type: MySQL
Server version: 8.0.19 - MySQL Community Server - GPL
Protocol version: 10
Server charset: UTF-8 Unicode (utf8mb4)
to the following target server:
Server type: MariaDB
Server version: 10.11.14-MariaDB-0ubuntu0.24.04.1 (Ubuntu 24.04)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8mb4)
During the database import/restore process, I receive the following error:
ErrNo #1273
Unknown collation: 'utf8mb4_0900_ai_ci'
(see attached screenshot)
It looks like the dump created on MySQL 8 uses the collation utf8mb4_0900_ai_ci, which is not supported by MariaDB 10.11.
Could you please advise on the best way to handle this migration?
Is there a recommended method within Akeeba to automatically convert or map this collation during restore, or should the SQL dump be modified manually?
Any guidance would be greatly appreciated.
Thank you very much!
I am migrating a Joomla site using Akeeba Backup from the following source server:
Server type: MySQL
Server version: 8.0.19 - MySQL Community Server - GPL
Protocol version: 10
Server charset: UTF-8 Unicode (utf8mb4)
to the following target server:
Server type: MariaDB
Server version: 10.11.14-MariaDB-0ubuntu0.24.04.1 (Ubuntu 24.04)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8mb4)
During the database import/restore process, I receive the following error:
ErrNo #1273
Unknown collation: 'utf8mb4_0900_ai_ci'
(see attached screenshot)
It looks like the dump created on MySQL 8 uses the collation utf8mb4_0900_ai_ci, which is not supported by MariaDB 10.11.
Could you please advise on the best way to handle this migration?
Is there a recommended method within Akeeba to automatically convert or map this collation during restore, or should the SQL dump be modified manually?
Any guidance would be greatly appreciated.
Thank you very much!
