Hi, I'm using amavisd-new 2.4.2 with MySQL for lookups. It's working really well, except I'm having a problem using the cleanup script that is included at the bottom of README.sql. It seems that on MySQL 5.0, the checking of foreign key constraints prohibits me from dropping the table indexes (not sure why that is, but I'm getting an error to that effect). It's too slow for me to run the script without dropping the indexes. I've tried googling the problem, and I found one post where someone was able to create a temporary MyISAM table, copy all the data he wanted to preserve into that table, truncate the old table, and then copy the data from the temporary table into the original innodb table. I was hoping I could come up with a simpler approach. Has anyone else already come up with a solution? Would I be better off just dropping the foreign key constraints temporarily while I'm cleaning out the older entries?
Thanks in advance, Cameron -- Webpipe.net ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ 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/
