php - utf8mb4_unicode_520_ci error when importing DB -


i exported wordpress database sequel pro , when trying import it, error:

unknown collation: 'utf8mb4_unicode_520_ci' 

i checked similar question , did these steps:

  • first when imported made sure compatibility changed none mysql40. (didnt work)
  • then opened sql dump in text editor , replaced "utf8mb4" "utf8" (didnt work)
  • i changed collection in phpmyadmin 'utf8_general_mysql500_ci' (didnt work).
  • i changed collection in phpmyadmin 'utf_unicode_ci' (didnt work).
  • i opened sql dump in text editor , replaced engine=innodb default charset=utf8mb4 collate=utf8mb4_unicode_520_ci; engine=innodb default charset=utf8 collate=utf8_general_ci; didnt work

how can import sql database ?

the same thing occurred me, when importing local wordpress database server.

open sql dump in text editor , set

charset utf8mb4

and

collate utf8mb4_unicode_ci


Comments