Fixed sinceThe problem described in this KB article has been completely fixed since Plesk 11.0.9 micro-update #34.
SymptomsA 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
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`testdb`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `testview`
CauseMost likely, the issue is occurring because the created database has views in it. Parallels Plesk Panel cannot handle such databases correctly.
ResolutionThe 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.
WorkaroundDownload 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.
chmod u+x restore_failed_databases.sh