Applicable to:
- Plesk 11.x for Linux
- Plesk 11.x for Windows
- Plesk 12.0 for Windows
- Plesk 12.0 for Linux
Symptoms
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
Cause
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)
Resolution
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)
Comments
0 comments
Please sign in to leave a comment.