purge data from maillog table

Questions and answers about how to do stuff
Post Reply
lelle
Posts: 13
Joined: 19 Aug 2014 07:59

purge data from maillog table

Post by lelle »

Hi all,

my mailscanner db has grown to fill the /var to 100%. It's the maillog table that is very big
Does anybody know how to purge the data but keeping the table.

/Lennart
User avatar
shawniverson
Posts: 3649
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: purge data from maillog table

Post by shawniverson »

Simple way....

In /var/www/html/mailscanner/conf.php

Code: Select all

define('RECORD_DAYS_TO_KEEP', 60);
Lower this number to your liking.

Then run the following...

Code: Select all

sudo /usr/local/bin/mailwatch/tools/Cron_jobs/db_clean.php
Post Reply