Search Our Database

How to create new DNS zone file In Plesk

Last updated on |
by

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.