MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’

When restoring a MySQL backup taken on MySQL 8 server, i get following error

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.

See MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *