Unknown collation: 'utf8mb4_unicode_520_ci' Print

  • 2

If you get the following error when trying to move a Wordpress site to another host:


> Unknown collation: 'utf8mb4_unicode_520_ci'

Try this:

1) Click the “Export” tab for the database

2) Click the “Custom” radio button

3) Go the section titled “Format-specific options” and change the dropdown for “Database system or older MySQL server to maximize output compatibility with:” from NONE to MYSQL40.

4) Scroll to the bottom and click “GO”.

If it’s related to wordpress, more info on why it is happening.


Was this answer helpful?

« Back