- Plesk 12.5 for Linux
- Plesk 11.x for Windows
- Plesk 12.0 for Linux
Unable to import a database with
utf8mb4charset. The following error appears in PhpMyAdmin:
#1115 - UNKNOWN CHARACTER SET: 'utf8mb4'
unknown collation 'utf8mb4_unicode_520_ci'
the database is imported to MySQL version 5.1
- the database is imported to MySQL version > 5.5.x, but different operating system distribution
charset is not supported by MySQL 5.1, or not supported in that OS distribution.
There are 2 ways to solve this:
1- Install MySQL server of version at least 5.5.3 using Plesk autoinstaller .
2- On the source server's MySQL, execute the next for each table of the database that cannot be imported (change $table_name by the name of the table):
ALTER TABLE $table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;