Mark Martinec skrev: > Dave, > >>> Indeed. That was the biggest win for me after switching to InnoDB. >>> >>> Previously I have been 'repairing' the Bayes database every once >>> in a while, and when left unattended for some time the bayes results >>> just deteriorated noticably - indicating a next repair is overdue. > >> Wow. Did you have this problem due to crashes, or just from >> regular use? > > Most likely due to frequent restarts of amavisd, which I do > during its development/testing. Crashes would also be a likely > reason for a database corruption. > > > Anders, > >> The problem I have is that all my ISAM tables are intact, and all the >> InnoDB are trashed beyond repair... I always had to recreate them from >> scratch to get up and running again. None of the tools provided by MySQL >> AB has been able to get them straight... > > Perhaps you could try a different versions of MySQL. > Which version are you running? > > Mark
I have 5.1.17, on my way to go to the latest, I just need the time to adapt it for SUSE use.. So far I haven't found the time.. I wonder where I put it.. ;) Anders. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/