- Plesk for Linux
Migration of the subscription fails with the following error:
PLESK_ERROR: Failed to copy content of database 'johndoe_db'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: mysql --defaults-file = /usr/local/psa/var/modules/panel-migrator/sessions/20180525101929/target-server /example.com_database.cnf -h example.com -P 3306 -uadmin johndoe_db </usr/local/psa/var/modules/panel-migrator/sessions/20180525101929/target-server/db-dumps/database.sql
exit code: 1
stderr: ERROR 1227 (42000) at line 66: Access denied; you need (at least one of) the SUPER privilege (s) for this operation
example.comis a remote MySQL server on the target server.
The SUPER privilige is not marked for the
adminuser in Plesk Source Server > Tools & Settings > Database Servers > MySQL > User Accounts > admin > Edit privileges.
The following error appears in an attempt to provide the admin user with the SUPER privilege:
PLESK_ERROR: # 1045 - Access denied for user 'admin' @ '%' (password used: SIM)
It is Plesk bug #PMT-4441 which will be fixed in future product updates.
As a workaround, perform the following actions:
Log into Plesk Source Server, go to Plesk Source Server > Subscriptions > example.com > Databases, create a database dump via the Export Dump button and download it after its creation.
Log into Plesk Destination Server, go to Plesk Destination Server > Subscriptions > example.com > Databases, click the Import Dump button, select the downloaded previously dump and press the OK button.
An alternative way for issue resolution which is not supported by Plesk - granting the admin user with SUPER privilege using this MySQL guide.