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_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?