[AMaViS-user] MySQL cleanup problem

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;198757...un.com/javaone
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/