I have just started to import the database using the warden command,
warden db import < project.sql
I am not able to import the Database using the above command and throws an error,
ERROR 1273 (HY000) at line 4048: Unknown collation: ‘utf8mb4_0900_ai_ci’
I have just researched and found the solutions to resolve this error by running the given command,
A solution to run:
sed -e 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' -i project.sql
Replace the word utf8mb4_0900_ai_ci with utf8mb4_unicode_ci using the above command.