Zone transfer to secondary name server via mysqldump...

Makefile

zone.txt: last_change
        pdnssec rectify-all-zones

        echo "SELECT name,type,content from records;" | mysql pdns > new_zone.txt
        diff zone.txt new_zone.txt > zone.diff
        rm zone.txt
        mv new_zone.txt zone.txt
        gzip --stdout zone.diff > diffs/zone.diff.$(date +"%Y%m%d%H%M")
        mysqldump pdns | ssh -i /root/.ssh/copydns_key ns3.teamwiki.net "mysql pdns"

				# maybe you want this mailed or jabbered somewhere
        # cat zone.diff | mail -s "Zone file changes" root
				# jabber [email protected] "Zone file changes\n $(cat zone.diff)"