Article ID: 120712, created on Mar 25, 2014, last review on May 11, 2014

  • Applies to:
  • Plesk 11.5 for Linux


Plesk backups fails the error:

    Error: domain "domain.tld" 
    Unable to create dump 
    Error: domain "domain.tld" 
    Broken referencial integrity: DNS zone id 219 is not found in dns_zone 


The record for domain is mising from psa.dns_zone table:

    # plesk db

    mysql> select * from dns_zone where id=219;
    Empty set (0.00 sec)


1) Backup Plesk databases before any changes:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > ~/psa_`date +%F_%H.%M`.sql

2) Access to Plesk database and add dns_zone for domain in dns_zone table:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa

    mysql> INSERT INTO `dns_zone` VALUES (219,'domain.tld','domain.tld',0,'true','true','test@domain.tld','master',86400,86400,10800,3600,3600,3600,604800,86400,10800,3600,'UNIXTIMESTAMP','1389108685')
    Query OK, 1 row affected (0.30 sec)

Search Words

DNS zone id is not found in dns_zone

DNS zone id is not found in dns_zone

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF