[work] Re: maillog.myi Cannot Insert row

[John Clancy]

Hi JP,

You need to have a text file containing the following two lines (with the
number of days adjusted to your taste):

delete low_priority quick from maillog where timestamp < (now() - interval
35 day);
optimize table maillog;

Then set up a crontab entry similar to:

/usr/bin/mysql --user=root --password=root_password mailscanner <
/home/user/clean_maillog.sql

JC

----- Original Message -----
From: "Jan-Peter Koopmann" <Jan-Peter.Koopmann at SECEIDOS.DE>
To: <MAILSCANNER at JISCMAIL.AC.UK>
Sent: 20 July 2004 07:33
Subject: [work] Re: maillog.myi Cannot Insert row


> Hi Ugo,
>
> > See MailWatch's archives for a script to clean MailWatch's DB.
>
> I just browsed the archives but did not find the script. You would not by
any chance have a copy of it and could send this to me?
>
> Regards,
>   JP
>
> -------------------------- MailScanner list ----------------------
> To leave, send    leave mailscanner    to jiscmail at jiscmail.ac.uk
> Before posting, please see the Most Asked Questions at
> http://www.mailscanner.biz/maq/     and the archives at
> http://www.jiscmail.ac.uk/lists/mailscanner.html
>

-------------------------- MailScanner list ----------------------
To leave, send    leave mailscanner    to jiscmail at jiscmail.ac.uk
Before posting, please see the Most Asked Questions at
http://www.mailscanner.biz/maq/     and the archives at
http://www.jiscmail.ac.uk/lists/mailscanner.html