Unknown collation: 'utf8mb4_0900_ai_ci'. mariadb code example
Example: 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"