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
Post a Comment