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
purge data from maillog table
- shawniverson
- Posts: 3649
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: purge data from maillog table
Simple way....
In /var/www/html/mailscanner/conf.php
Lower this number to your liking.
Then run the following...
In /var/www/html/mailscanner/conf.php
Code: Select all
define('RECORD_DAYS_TO_KEEP', 60);
Then run the following...
Code: Select all
sudo /usr/local/bin/mailwatch/tools/Cron_jobs/db_clean.php