- Plesk 12.5 for Linux
- Plesk 12.5 for Windows
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)
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
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\ mp22587.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.