Rocco, > I didn't know about this feautures of SA 3.1. Infact I created MyISAM > tables... so now I have to: > 1) migrate bayes db on flat files again > 2) drop the db > 3) create the db with InnoDB storage engine > 4) migrate db from flat files to new DB > > :(
No need to go the long way. You can covert MyISAM to InnoDB table with a SQL command: ALTER TABLE ... ENGINE=INNODB See MySQL documentation for details. > PS: If I decide to mantain the MyISAM storage engine, how I have to > 'repair' the bayes db manually? Yes, it doesn't hurt to do REPAIR on busy MyISAM tables every once in a while, especially before a conversion. And OPTIMIZE TABLE may be useful too: $ mysql sa REPAIR TABLE bayes_expire, bayes_seen, bayes_token, awl; OPTIMIZE TABLE bayes_expire, bayes_seen, bayes_token, awl; Mark ------------------------------------------------------- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
