[NTLUG:Discuss] Relaydelay delight

[. Daniel]

Working my way through the completion of a spam-free weekend, I check my 
email and that's all I see!  My email!  Nothing extra.  Nothing I didn't 
ask for or ask to cease.

My database tables, I fear, will be filling as are my logs.  I have 
installed a log rotater, but I'm unsure about purging the expired records 
in my "relaytofrom" table.  What would be the query to clear them out?  I'm 
not an SQL person at all.  I just barely understand what it is.

So my burning question is:

How do I set up a routine to purge the expired entries from the tables?  I 
know it'll be a cron job.  I'm pretty sure some perl script will be the 
delivery system.  And I'm certain it will be the execution of one, maybe 
two queries to MySQL.  The problem is I don't know how to make those happen 
in detail.  I know what, but not how.

I use webmin's MySQL module as the means to examine the tables' contents.  
It really tickles me inside to see all the junk being turned away and all 
the good stuff being allowed through.  I understand the logic and it just 
seems too simple to work, and yet it does and it's ever so effective.  
Concisely put:

"The REAL Postman knocks twice." (The spammer does not)

It's a beautiful thing.

_________________________________________________________________
節約のアイディア300例。お金の悩みは、MSN マネーで自己解決 
http://plan.money.jp.msn.com/saving/index.html