How to fix #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL query error


Hello Friends, Today we will learn how to resolve MySQL error in WordPress #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’.

Actually, this is a very big problem we are facing when we are importing WordPress Database from one host to another host in PHPMyAdmin or even sometimes the same server.


So guys, below steps will help us how to fix this #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL issue.

STEP 1: Download your Database file in [.sql] format.

STEP 2: Open your Database file either in Macromedia Dreamweaver or in Notepad++ software and give Search & Replace command ctrl+F

STEP 3: After that put “utf8mb4” on search and replace with “utf8”. Now it will replace the utf8mb4_unicode_520_ci to utf8_unicode_520_ci.

STEP 4: Now we have to replace one more thing, put “utf8_unicode_520_ci” in search and replace with “utf8_unicode_ci

STEP 5: Now we go to PhpMyAdmin and set the DB collation to utf8_unicode_ci (Operations >> Collation).

Try this, it’ll really work.



Please share your thought

Looking for fresh content?

Access free WordPress resources such as videos, plugins, and other helpful tools and offers.