In the binary MySQL server (5.0.18) distributed with FC5 final release, have_archive=NO, that is, the ENGINE=ARCHIVE option is not available. I understand that to turn it on requires setting a compile time option. A user raised this with the archive forum at mysql on 14Oct2005 (version 5.0.13) and was advised this would be fixed "in the next version":
Seems it was not. (:-(( I have re-raised it on that forum:
but think it might be helpful to raise it here, FYI and also as I assume fixing this might be a task for FC folk as well as MySQL folk.