Let’s start the discussion about mariadb unknown collation: ‘utf8mb4_0900_ai_ci’ in following Approaches.
This problem, I assume, is caused by the fact that the local and live servers are running different versions of MySQL. Here’s how to fix it: In your text editor, open the sql file. Replace all instances of utf8mb4 unicode 520 ci with utf8mb4 unicode ci. Save and upload to a new MySql database.
Contents
mariadb unknown collation: ‘utf8mb4_0900_ai_ci’ ?
I just opened the dump.sql file in Notepad++ and
hit CTRL+H to find and replace the string
"utf8mb4_0900_ai_ci" and replace with "utf8mb4_general_ci"
I hope the strategies listed above work for you. Happy coding and come back again.
Similar Post : How to check run time in c