Unable to import a database: UNKNOWN CHARACTER SET: utf8mb4*

Created:

2016-11-16 13:05:21 UTC

Modified:

2017-08-16 17:27:41 UTC

4

Was this article helpful?


Have more questions?

Submit a request

Unable to import a database: UNKNOWN CHARACTER SET: utf8mb4*

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Linux

Symptoms

  • Unable to import a database with utf8mb4 charset. The following error appears in PhpMyAdmin:

    #1115 - UNKNOWN CHARACTER SET: 'utf8mb4'

or

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

Cause

utf8mb4 charset is not supported by MySQL 5.1, or not supported in that OS distribution.

Resolution

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;

Have more questions? Submit a request
Please sign in to leave a comment.