Symptoms
Migration from servers with MySQL<5.5 fails with the following error:
Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (xxx.xxx.xxx.xxx) with non-zero exit code.
command: MYSQL_PWD="$(cat)" mysqldump --no-defaults -h localhost -P 3306 -uadmin --quick --quote-names --add-drop-table --default-character-set=utf8mb4 --set-charset --routines --events mfr_challenge > /root/plesk_migrator/plesk_migrator-51m5u6ctan6dl9j4k857iojlidj8f1qp/db-dumps/mfr_challenge.sql
exit code: 1
stdout:
stderr: mysqldump: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
Cause
Product issue:
-
#PMT-5050 "Migration no longer fails with the “Character set ‘utf8mb4’ is not a compiled character set” error when migrating from outdated MySQL/MariaDB servers."
Fixed in:- Plesk Migrator 2.22.1 20 September 2022
- Site Import 1.6.1 20 September 2022
Resolution
Workaround
If update is not possible for some reason you may try the following
workaround
Until the bug is fixed, the following workaround is available:
- Connect to a Plesk server via SSH.
- Change 'utf8mb4' to 'utf8' in /usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/utils/database_utils.py file
with