[Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

[Pavel Ondřej]

Hi, the easist way is this software:
https://www.devart.com/dbforge/mysql/datacompare/

Pavel

2015-05-08 19:31 GMT+02:00 Jan-Piet Mens <jpmens.dns at gmail.com>:

> > What do you guys think would be the best approach for comparing two
> > PowerDNS MYSQL databases that are supposed to hold the same domains
> > and records?
>
> Instead of mucking about with SQL what I would probably do is configure
> both servers as masters; then, on each, AXFR each of the zones, and use
> Tony Finch's `nsdiff' utility to diff the results.
>
> If I could only go the SQL way, I'd probably write a script which dumps
> the domains and records tables on each (sorted) and diff those; it'll at
> least give you an indication on whether there actually are differences.
>
>         -JP
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20150508/66b7a4dc/attachment-0001.html>