Re: Deleting of records older than a specific date & time

[a.smith]

Quoting Machiel Richards <machielr@stripped>:


>
>         We need to be able to delete all data from the 2 tables that is
> older than the start of yesterday.
>

Hi,

   I use this veryyyy simple script to purge data from a syslog DB:

#!/usr/local/bin/bash
/usr/local/bin/mysql -u syslog -pmypasswd -e 'DELETE FROM SystemEvents  
WHERE ReceivedAt < date_add(current_date, interval -60 day)' Syslog

maybe that is useful for you...?

cheers Andy.