[Pdns-users] Deactivating zone in MySQL

Jan-Piet Mens jpmens.dns at gmail.com
Tue Nov 5 09:01:23 UTC 2013


> I'm using the Mysql backend and administering using Poweradmin.  Is
> there a way of "de-activating" a zone - other than simply deleting
> it from the database?

What some people do is to add a column to the domains table (`active
INTEGER DEFAULT 1`, or something like that) and alter the SQL queries
PowerDNS uses to include " ... AND active = 1". That does the trick
rather nicely.

Check the documentation on how to alter the queries.

        -JP




More information about the Pdns-users mailing list