ok, solved.
first, i had to find all the records in messages that did not appear in
messageblks. I used the following command:
select messages.* from messages left join messageblks on
messages.physmessage_id=messageblks.physmessage_id where
messageblks.physmessage_id is null ;
then I had to delete all the messages records with the following command:
delete from messages where message_idnr=xxxxx;
workes for me, but now to find out if the rest of the users are good to
go.
ed
On Wed, 1 Sep 2004, Ed K. wrote:
Ok, so this morning the server wan't working properly - probably because the
partition that MySQL was on ran out of space. So the netwok admin just
rebooted the box.
After the reboot, and a MySQL table recovery, and a dbmail-maintenance -cfpd,
the system is still not working properly. a 'BYE internal dbase error' is
being sent back to the clients without any email message bodies.
Logs are all verbose, but very big, so if you want 'em i'll get them to
you.
any suggestions?
ed
p.s. using dbmail cvs checkout from aug 9th, and mysql
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
