Check and Move database between different subscription
Issue: Database is not showing under the original Subscription from Plesk Panel
Observation: With the following command it is found under which subscription the database is currently exist. ( example database in the below command: chandist_steeldbl )
[root@plesk06 ~]# plesk db "select db.name as 'Database',d.name as 'Subscription',c.pname as 'Owner',c.login as 'Customer Username' from data_bases db,domains d,clients c where d.cl_id=c.id and db.dom_id=d.id" |grep chandist_steeldbl
Resolution: On the Plesk Panel Go to the Subscription the database is currently attached >> Click on Databases >> Click on Move to Subscription Tab
.PNG)
Select the destination subscription from the drop down box and press OK
