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:
and replace with:
That’s it!. Hope someone finds this simple guide useful.