MonitorWare Knowledge Base

First of all - big kudos to Rainer Gerhards for helping me with everything!!

Now I only need to be an MySQL-expert as well

How do I setup db to "clean logs" every 12th hour ??? As it is for now, im getting like a 100,000 entries in db, hehe...

Im using Debian Sarge.....

• Custom written rsyslog.conf?
• Maintenance Contract?
• Installation support?

Hello,

You can start a script via cron job, e. g.

Code: Select all

mysql -u database-userid -pdatabase-password -e "truncate table SystemEvents" database-name


to delete all data or like

Code: Select all

mysql -u database-userid -pdatabase-password -e "DELETE FROM SystemEvents WHERE ReceivedAt < date_add(current_date, interval -1 day)" database-name


to delete data older than one day.

Hope this help.

Michael

I was wondering if someone out there is backing up the DB prior to purging it?
If there is already a script out there someone wrote for backing up the syslog data before you clear out the log info that would be great. If not hopefully I could post one up here in a week or so.

Thanks,
Javier