Search Our Database
How to create new DNS zone file In Plesk
If you are experiencing the following issues:
1) Domain name DNS zone file record in Plesk is not working.
2) DNS zone file is not found in the Plesk DNS zone folder.
3) The issue is not resolved after restoring it to default settings.
To solve the aforementioned issues, you need to recreate a DNS zone.
Step 1 – Search invalid DNS records in the Plesk database.
cd C:\Program Files (x86)\Parallels\Plesk\admin\bin
"%plesk_bin%\dbclient" --direct-sql --sql="select id,name from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases) and id <> (select val from misc where param = 'default_dns_zone_id')"
Step 2 – Remove any invalid DNS records.
cd %plesk_dir%\Mysql\bin
Step 3 – Login into Plesk MySQL.
mysql -uadmin -p -P 8306 psa
Step 4 – Delete DNS records. Delete records: 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) and id <> (select val from misc where param = ‘default_dns_zone_id’);
delete * from dns_zone where id=101;
Step 5 – Exit MySQL.
Step 6 – Update your DNS records.
cd C:\Program Files (x86)\Parallels\Plesk\admin\bin
DNSMng.exe Update *
Step 7 – Login into Plesk and restore DNS records to default settings.