maillog.myi Cannot Insert row

[Pete]

Thanks Ugo, yes i have that script already, but i had poorly configured
the cron job for it.

The fix for the error is to folllow
http://dev.mysql.com/doc/mysql/en/Repair.html this guide on databse
repair, on a volume that has at least the same amount of space free as
the DB currently occupies. Since ym var was ultra low on space, i moved
the entire DB to /usr, did my repairs and brought it back, fixed up the
ownership[ and perms i buggared up by moving it and restarted mysql and
mailscanner = all fixed :)

thanks
Pete

> Pete wrote:
>
>> Today i have started seeing
>> Cannot insert row: Can't open file: 'maillog.MYI'. (errno: 144)
>> in my log file a lot. The Maillog.myd file is 130mb, so i would love to
>> be 'reset' this. Can i just delete these files and restart?
>
>
> no, you'd lose the table's structure.
>
> See MailWatch's archives for a script to clean MailWatch's DB.
>

-------------------------- 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