WordPress Unknown Collation utf8mb4_unicode_520_ci Solution

If you're importing or migrating your WordPress database to a server that has an older version of MySQL (like version 5.5.x), you may run into this error:

Unknown collation: ‘utf8mb4_unicode_520_ci’
The utf8mb4_unicode_520_ci collation is available in MySQL versions 5.6.x and newer, and WordPress utilizes that collation if it's available during installation. To be able to successfully import or migrate to a server with an older MySQL version, you have one of three options:

If you have the exported .sql file, you can do a simple Find & Replace using a text editor such as Notepad++, replacing all occurrences of utf8mb4_unicode_520_ci with utf8mb4_unicode_ci:

Search Mode: extended

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Run OPTIMIZE TABLE to defragment tables for better performance

For this suggestion:Run OPTIMIZE TABLE to defragment tables for better performanceRun this...

How to clear Error Log of a cPanel Account.

User the below code to clear Error Log:Replace User with Username:Code:for i in `find...

What is php.ini ?

The php.ini file and changing PHP Settings The php.ini file is a special file for PHP and...

How to fix ini_set() has been disabled for security reasons

1. Create php.ini file inside your public_html folder, OR the folder in which you have...

How to fix Fatal error: Uncaught exception 'Exception' with message 'DateTimeZone:

1: Create .htaccess file inside your public_html folder, OR the folder in which you have...