Back to the backup of your mail archive and try again. Once in a while, make an extra copy and compact the database. If it fails somewhere, go back to your latest copy.

You might see if there are OE recovery and repair programs available for the Mac. Those, most likely, aren't free.