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