Importing SQL – 520 ci-error

If you are exporting a database from an older MySQL server such as 5.5.3 and are importing it to a newer MySQL server, you might receive 520 ci-error that appears such as:

#1273 – unknown collation ‘utf8mb4_unicode_520_ci’

There is an easy way to fix this error. Simply open your favorite notepad, and find:

utf8mb4_unicode_520_ci

and replace with:

utf8mb4_unicode_ci

That’s it!. Hope someone finds this simple guide useful.