Migration from Plesk servers with MySQL<5.5 fails: Character set 'utf8mb4' is no

[Administrator]

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

[/size]
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