Fixed sinceThe problem described in this KB article has been completely fixed since Parallels Plesk Panel 11.5 (see release notes).
SymptomsMigration of a domain from between Parallels Plesk Panel (PP) servers fails if the domain has databases created with "SJIS" character set on the source server.
An example of error message which can be displayed by the migration manager:
Failed deployment of database evolve (domain domain.tld)
An example of error message from the migration.log:
ERROR at line 281 in file: '/tmp/migration-unpack-U4AhLf/backup_evolve_1_1204171131': Unknown command '\<96>'.
CauseDatabase is dumped with 'mysqldump --default-character-set=sjis', but the restoration is done with default charset, which is latin1 or UTF-8.
ResolutionThe issues will be fixed in a future update. You may subscribe for Parallels Panel Products Updates mailing list if you wish to receive notifications about the latest product updates, new version announcements, promotions and more for Parallels Plesk Panel, Parallels Small Business Panel and Parallels Plesk Billing.
WorkaroundNote: The below workaround is only for PP 9.5.4 servers. However, all Linux distributions and architectures for 9.5.4 version are supported.
In order for the migration to work properly you need find the following files on the destination server:
and replace them with these patched versions using the correct procedure for hotfix installation:
8083 How to install Panel hotfixes in Linux properly