Article ID: 115066, created on Oct 31, 2012, last review on Aug 12, 2014

  • Applies to:
  • Plesk 11.x for Linux
  • Plesk 10.x for Linux

Fixed since

The problem described in this KB article has been completely fixed since Plesk 11.0.9 micro-update #34.


A domain owner creates a MySQL database for one of their domains. When they try to back up and restore or migrate the domain, the database is not restored and the following error occurs:

Failed deployment of database testdb (domain domain.tld)
Execution of /usr/bin/mysql --no-defaults -u backup_xxxxxx -h localhost -P 3306 testdb failed with return code 1.

ERROR 1227 (42000) at line 4715 in file: '/tmp/migration-unpack-2ugN6D/backup_domain_tld__1_1211190908': Access denied; you need the SUPER privilege for this operation
/*!50013 DEFINER=`testdb`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `testview`


Most likely, the issue is occurring because the created database has views in it. Parallels Plesk Panel cannot handle such databases correctly.


The issue will be fixed in a future update for which a new Knowledgebase article will be created. You may subscribe to new articles on Parallels Plesk Panel products if you wish to receive notifications about their creation.


Download this shell script, unzip it, and run it on the destination server (you may use the below commands to do it):

It will automatically identify and restore the failed databases.

Shell commands:

chmod u+x


dd0611b6086474193d9bf78e2b293040 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF