Re: Zone Files

From: Joe Baptista (baptista@pccf.net)
Date: Sun Jun 04 2000 - 20:24:45 EDT


Sure - just parse it sort the records and load into a database.

Joe Baptista

dot.GOD Hostmaster
+1 (805) 753-8697

On Sun, 4 Jun 2000, Chronos wrote:

> This may sound like a dumb question.
> Can you import it into MS SQL server ??
>
>
>
>
> ----- Original Message -----
> From: <pccf@pccf.net>
> To: "Sven Echternach" <sven@sec.de>
> Cc: "Ken Hirsch" <KAHirsch@san.rr.com>; <discuss-list@opensrs.org>
> Sent: Sunday, June 04, 2000 3:43 PM
> Subject: Re: Zone Files
>
>
> >
> > On Mon, 5 Jun 2000, Sven Echternach wrote:
> >
> > > Some ideas:
> > >
> > > - The mostly discussed UNIX "diff" did not work for me (esp. for files
> over
> > > 100 MB in size).
> > > - I tried to write up something in Perl, but it's not 100% functional
> yet.
> > > Also it requires the two zone files to have the domains in the same
> order.
> > > With a small awk and uniq script, you can at least extract a list of the
> > > domain names.
> > >
> > > Does anyone know how the order of domains in the zone files is made up?
> > > Unfortunately new domains do not seem to be appended at the end or
> > > beginning. And sorting such a huge file (e.g. using UNIX "sort") does
> not
> > > work either with regular resources.
> >
> > I assume your playing with the dot.com zone file - what is it these days
> > ??? should be over 1.5 gigs.
> >
> > The way we handled it was to rewrite diff. The zone may not be in
> > any specific order. Do you ftp the zone - or axfr it?
> >
> > Your could always sort the records into mysql and then manipulate the data
> > there.
> >
> > Joe Baptista
> >
> > dot.GOD Hostmaster
> > +1 (805) 753-8697
> >
> > >
> > > Cheers, Sven
> > >
> > > At 23:55 01.06.2000 -0700, you wrote:
> > > >Does anyone have a recommendation on what software to utilize to
> compare
> > > >sequential zone files? Needless to say, something like Excel crashes at
> the
> > > >mere thought...
> > > >
> > > >Thanks!
> > > >
> > >
> > >
> > >
> >
>



This archive was generated by hypermail 2.1.3 : Tue Oct 19 2004 - 23:35:37 EDT