Database backup restoration failing from Plesk: TRIGGER command denied to user

Created:

2016-11-16 12:58:21 UTC

Modified:

2017-04-24 12:01:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Database backup restoration failing from Plesk: TRIGGER command denied to user

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

  • Trying to restore a database backup fails with the error:

    ERROR 1142 (42000) at line 202 in file: '/tmp/migration-unpack-oHWAvN/backup_1602021409': TRIGGER command denied to user 'backup_7Sgw37C'@'localhost' for table 'table1' [ExecCmd.cpp:68] void plesk::ExecCmd::reportError() const
  • Restoring from command line works:

    mysql -uadmin -p$(cat /etc/psa/.psa.shadow) wordpress_f < database_backup

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.