MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’
When restoring a MySQL backup taken on MySQL 8 server, i get following error
1 2 3 |
boby@sok-01:~/Downloads$ mysql mage2 < magento2-2021-01-27-1-54.sql ERROR 1273 (HY000) at line 11762: Unknown collation: 'utf8mb4_0900_ai_ci' boby@sok-01:~/Downloads$ |
To fix this error, open the file in a text editor, find utf8mb4_0900_ai_ci, replace with utf8mb4_unicode_ci.
I used following sed command to do the replace.
1 |
sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' magento2.sql |
See MySQL