Morning everyone, Over the last few days I have been having some very frustrating experience with dbmail and I haven't been able to totally narrow it down to an issue with the server, mysql server, or dbmails injection into the database.
dbmail version: 2.0.7 Apparently the server that I am having these issues with restarted abruptly the other night due to power loss, at which time it seems that the database got corrupt. I was able to do innodb_force_recovery = 1 in the my.cnf file so that I could get a clean dump of the database since my other backup solution had failed .... After I got the clean dump of the database, I dropped my old dbmail database completely that still had corrupt data in it. I recreated the database inserted the data back into the system from the dump file. Everything seem to work fine for several hours .... last night the db was showing up corrupt again ... and it is only the dbmail_messageblks table that is showing corrupt. Anyone else had issues? Anyone have any ideas? Thanks ... -Erik