[Solved] Unknown collation “utf8mb4_unicode_ci”

Oh my god it’s some time very pain while restoring the DB. It shows the collation mismatch ERROR 1273 (HY000) at line 25: Unknown collation utf8mb4_unicode_ci

A collation is a set of rules that defines how to compare and sort character strings. Each collation in Mysql belongs to a single character set. Every character set has at least one collation, and most have two or more collations.

The different types are in form of uf8,utf8 etc..

Generally the collation mismatch occurs due to while restoring DB to different Mysql versions( Eg : mysql 5.6 to mariadb 5.5 )

Error

ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_unicode_ci'

[Solved] Unknown collation “utf8mb4_unicode_ci”

sed -i 's/utf8mb4/utf8/g' db_name.sql


sed -i 's/utf8mb4_unicode_ci/utf8_general_ci/g' db_name.sql

That all..you can restore the DB now…:)