Erik Kristensen wrote: > 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 ...
Did you start from fresh innodb data files? -- ________________________________________________________________ Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] The Netherlands________________________________http://www.nfg.nl
