- Plesk 12.5 for Linux
- Plesk 12.5 for Windows
Note: This article has the reference to the issue with the fix available:
"MySQL database views were not restored from backup, if the value of the “Default settings for remote access of database users” option in Database Hosting Settings was changed to “Allow local connections only”."
- Plesk 12.5.30 Update 22 15 February 2016
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.