I have a mysql 8.0 that I exported using mysqldump. I am trying to import it onto a Mariadb 10.4 database with phpmyadmin, both are the most current versions. Each time I do it though, I get:
Error: Unknown collation utf8mb4_0900_ai_ci
Then I went back into the sql file and replaced utf8mb4_0900_ai_ci
with utf8mb4_general_ci
, but then it says there are errors with various CREATE VIEW
sql statements. Are there any other quick, error free fixes I can try?
SHOW CREATE VIEW
. MySQL 8 has a lot of enhancements that may not transfer to MariaDB. I would recommendutf8mb4_unicode_520_ci
as being a compromise between 'general' and '0900'.VISIBLE
shows up as an error, simply remove it.mysqldump
to create the SQL dump file.