> if you're already going to the effort of downloading the entire > blacklist every night, why not dump the old database, and just insert > the newly downloaded one? Because we also add our own entries to the current blacklist so we are just adding any new entries from the nightly updates of our blacklist provides >> tar -cxf blacklist.tar > > this will suck your computer into a vortex of doom. I recommend either > creating a tarball, or extracting one, but not both at the same time. :) Its ok the blacklist is text so its a 10mb tarball of text. Takes about 30 seconds to download and it will take about 2 minutes for the script to run ;) > In all honesty, you might be better targeting this query to squidGuard > users, as this may be something they do regularly. Should be simple text manipulation :( none the less a good idea I will post my question there. Thanks! -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GIT/MU/U dpu s: a--> C++>$ U+> L++> B-> P+> E?> W+++>$ N K W++ O M++>$ V- PS+++ PE++ Y+ PGP t 5 X+ R- tv+ b+> DI D+++ G+ e(+++++) h--(++) r++ z++ ------END GEEK CODE BLOCK------