Problem – Unknown Character Set: ‘Utf8mb4’
Recently, Our WordPress Developer was moving a new build WordPress website site from our Development server to Client Plesk panel hosting. in most of cases MySql Database Import / Export completed without any error but sometime it put you in trouble and you cant make Client site live on their server in given time duration due to getting unexpected error. With Client Plesk panel we getting Unknown Character Set: ‘Utf8mb4’ error while import MySql Database file which exported from our Server.
According error Plesk panel current MySQL version didn’t recognise utf8mb4 as a valid character set.
Solutions for Unknown Character Set: ‘Utf8mb4’ Error
1. During exporting database from phpMyAdmin, choose Custom from Export Method.
2. Under Format-specific options section,
Database system or older MySQL server to maximize output compatibility with: Selection option to MYSQL40.
This will change the character set of the tables from utf8mb4 to utf8 and your database will now import correctly on Plesk Panel.
Alternative solution for Unknown Character Set: ‘Utf8mb4’ in PhpMyAdmin Mysql
If above method not work for you you can give chance to below trick
– Open sql file by text editor (Notepad++, Sublime etc) and run find and replace for following
utf8mb4 to utf8
Fix Unknown Collation: ‘Utf8_unicode_520_ci’ while Import MySql Database
open the .sql file in a text editor, and use the ‘find and replace’ tool:
find: utf8_unicode_520_ci and replace: utf8_unicode_ci
After replace all utf8_unicode_520_ci to autf8_unicode_ci, you should then be able to import the database as normal and it will be work fine.