This issue is as a result of your server not supporting the utf8mb4_unicode_520_ci
collation type.
To resolve this you should convert the collation for all tables with utf8mb4_unicode_520_ci
to utf8_general_ci
If you’re exporting through phpmyadmin, you can:
-
Click the “Export” tab for the database
-
Click the “Custom” radio button
-
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. -
Scroll to the bottom and click “GO”.
OR run the following query on each of the affected tables:
ALTER TABLE myTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
UPDATE:
You should also replace in your sql exported file TYPE=MyISAM
with ENGINE=MyISAM