Issue
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 :
My problem is that the import stops and I have errors :
Why is it not working ?
Solution
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