When importing database, it shows error

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:

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”.

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