For Plesk on Windows
- Connect to the Plesk server via RDP.
- Start a command prompt as an Administrator.
- Create a database dump of the Plesk database plesk db dump psa > C:\psa_backup.sql
- Access the Plesk database: plesk db
- Run these commands to remove orphaned records: delete from dns_recs where dns_zone_id in (select id from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases)); delete from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases);
- Exit MySQL: mysql> exit
- Create the domain/subdomain/alias in Plesk / Rerun the migration/restore.