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

utf8mb4_unicode_520_ci

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.

Share:

Facebook
Twitter
Pinterest
LinkedIn

Please share your thought

All the tools you need to build professional forms online.

Create custom web forms to capture leads

Collect payments

Automate your workflows

Build your business online

Create custom web forms to capture leads, collect payments, automate your workflows, and build your business online