utf8mb4_unicode_520_ci error when importing DB

Question

I exported a WordPress database from Sequel Pro and when trying to import it, I get this error:

Unknown collation: 'utf8mb4_unicode_520_ci'

I checked this similar question and did these steps:

• First when I imported I made sure compatibility is changed from NONE to MYSQL40. (didnt work)
• Then I opened the sql dump in text editor and replaced all "utf8mb4" to "utf8" (didnt work)
• I changed collection in phpMyAdmin to 'utf8_general_mysql500_ci' (didnt work).
• I changed collection in phpMyAdmin to 'utf_unicode_ci' (didnt work).
• I opened the sql dump in text editor and replaced all ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; to ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; but didnt work

How can I successfully import this sql database ?

Answer 1

The same thing occurred to me, when i was importing local wordpress database to server.

Open the sql dump in text editor and set

CHARSET to utf8mb4

and

COLLATE to utf8mb4_unicode_ci