During the restoration process, the following error occurs:
Execution of /usr/bin/mysql --no-defaults -u backup_410QPkk -h localhost -P 3306 --default-character-set utf8 *database name* failed with return code 1. Stdin is source /tmp/migration-unpack-tfiayb/backup_*backup date*; exit Stderr is ERROR 1227 (42000) at line 76 in file: '/tmp/migration-unpack-tfiayb/backup_*backup date*': Access denied; you need (at least one of) the SUPER privilege(s) for this operation
"Home -> Tools & Settings -> Database Servers -> Database Hosting Settings -> Allow remote connections from any host "
is turned off.
Also, the following error may appear during restoration process:
Warning: Restore domain "example.com" Failed deployment of database example_db (domain example.com) Warning: Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases\example_db_1[sqldump]: Hs_full_example_db_1_sqldump_1601110901.zip Warning: Execution of "C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\/mysql" --no-defaults -u backup_o2wVK28 -h localhost -P 3306 --default-character-set utf8 example_db failed with return code 1. Stdin is source C:\Program Files (x86)\Parallels\Plesk\PrivateTemp/migration-unpack-01d1542c6031ddb0/tmp22587.tmp exit Stderr is ERROR 1370 (42000) at line 926 in file: 'C:\Program Files (x86)\Parallels\Plesk\PrivateTemp\migration-unpack-01d1542c6031ddb0\tmp22587.tmp': alter routine command denied to user 'backup_o2wVK28'@'%' for routine 'example.routine'
This is a software issue with internal ID #PPPM-3628. The issue is fixed in Plesk 12.5 MU #22.
Install the latest microupdates using Plesk autoinstaller.