Article ID: 128229, created on Feb 3, 2016, last review on Feb 19, 2016

  • Applies to:
  • Plesk 12.5 for Linux


  • 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


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.

Search Words

TRIGGER command denied to user


742559b1631652fadd74764ae8be475e 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF