Failed to restore server backup: command denied to user backup_o2wVK28

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 12.5 for Windows

Created:

2016-11-16 13:00:26 UTC

Modified:

2016-12-21 19:44:33 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Failed to restore server backup: command denied to user backup_o2wVK28

Symptoms

  1. 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
  2. The option

    "Home -> Tools & Settings -> Database Servers -> Database Hosting Settings -> Allow remote connections from any host "

    is turned off.

  3. 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\ mp22587.tmp': alter routine command denied to user 'backup_o2wVK28'@'%' for routine 'example.routine'

Cause

This is a software issue with internal ID #PPPM-3628 . The issue is fixed in Plesk 12.5 MU #22.

Resolution

Install the latest microupdates using Plesk autoinstaller.

Have more questions? Submit a request
Please sign in to leave a comment.