Support

Hi,

I was trying to restore a WP site from OVH (MySQL 8) to PlanetHoster (MariaDB) and I got the following error.

I think it is a very similar to the issue 

https://www.akeeba.com/support/akeeba-backup/40425-restore-error-from-mysql-8-to-mariadb-for-utf8mb4-0900-ai-ci.html

but since I am using Akeeba Backup 9.0.6 and Kickstart 9.0.0 the solution cannot apply (I see that the files have been reorganized and rewritten).

How can I fix this ?
(even a workaround is good enough atm)

Txs Nicholas !

Marc Dechèvre aka Woluweb

Database restoration An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
The error received was:
Database error processing line 2
Database server error reply: ErrNo #1273
Unknown collation: 'utf8mb4_0900_ai_ci'
Raw query text:
CREATE TABLE `bf_folders_to_scan` ( `id` int NOT NULL AUTO_INCREMENT, `folderwithpath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Waouw, that is wonderful !

I had not noticed this Option "Normalise Character Set" in the restoration script's Database Restoration page :)

I guess it is new. But I must say

• it is the first time I run into such a MySQL8 vs MariaDB collation issue
• it is also the first time I am using version 9 of Kickstart :)

Thank you so much !

Indeed it all went fine.

PS : you can make this post public, it can be useful for others (I will quickly delete all the personal info like folders right now)

(oh, it seems I cannot edit my original Post. If you can simply remove the "Debug information" block then feel free to make this ticket Public. It will certainly help others)