Error: Unknown collation while importing SQL dump file
Posted: Wed Nov 09, 2022 10:40 am
If you run:
And get this error:
To fix this, run the following:
After that, rerun:
That's all Folks!
Code: Select all
mysql user_database_name < dump_of_database.sql
Code: Select all
ERROR 1273 (HY000) at line 352838: Unknown collation: 'utf8mb4_0900_ai_ci'
Code: Select all
sed -i "s/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g" dump_of_database.sql
Code: Select all
mysql user_database_name < dump_of_database.sql