Domain database is not being migrated, migration completes with the following warning:
Warning: domain "domain.com" Failed deployment of database domain_com_lp (domain domain.com) Warning: Failed to attach existing remote database domain_com_lp (domain domain.com). For security reasons data management does not supported for databases, which has no database users assigned
domain_com_lp database is located on the local server.
The following error can be observed in the
Unable to connect to database using supplied credentials
Database is not migrated due to credentials issue.
Also such warning may occur if there is no any user created under this database on the source server.
First of all check if at least one user exists under this database. If it does then follow the steps below.
Create database backups on both source and destination servers:
mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` psa > /tmp/psadump.`date +%F_%H.%M`.sql mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` mysql > /tmp/mysqldump.`date +%F_%H.%M`.sql mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` --all-databases > /tmp/all.`date +%F_%H.%M`.sql
On the source server change user credentials of the
domain_com_lpdatabase: go to Subscriptions > domain.com > Websites & Domains > Databases > domain_com_lp > domain_com_lp_user
On the destination server drop the database in question:
mysql> drop database domain_com_lp
- Try to migrate one more time.