collate=utf8mb4_0900_ai_ci error 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"