How to migrate a MySQL 8 database to MariaDB 10.5?


I want to migrate my MySQL 8 database to MariaDB 10.5

I exported my MySQL database to a ".sql" file.

I tried importing it with PhpMyAdmin to MariaDB :

enter image description here

My problem is that the import stops and I have errors :

enter image description here

Why is it not working ?


on linux you can make sed -e 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' -i myfilename.sql

As you see, you have to replace the collation through the complete sql file

Answered By – nbk

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published