• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Issue ERROR 1273 (HY000) utf8mb4_unicode_520_ci

eslammahmoud

New Pleskian
Failed to copy content of database 'move3afs_wp'
Migration tools tried to perform operation in 1 attempts: Restoration of MySQL database failed. Most probable reason:

Target MySQL server does not contain necessary character set.
Most likely it is required to have at least MySQL 5.5 to restore such database.

Proposed solutions:
*) Obtain another target server which has OS providing appropriate MySQL server version.
For example, CentOS 6 provides MySQL 5.1 by default, while CentOS 7 provides MySQL 5.5 by default.
*) Connect another external MySQL server to the target server with appropriate MySQL version.
Configure that server as default, or specify it in service plan to which subscriptions are assigned to.
Remove migrated subscription from the target server and start migration once more.
*) Upgrade MySQL server on the target server to appropriate version, then run migration once more (no need to
remove subscriptions from target - just run migration over existing domains). For example, for CentOS you could use
packages provided by EPEL repositories. This way is not recommended for servers already running in production.

Here is the original error message reported by MySQL client when restoring the database:
ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_unicode_520_ci'

How to solve the problem?
 
Back
Top