mbox to mysql

Question

Hey Everyone,

Has anyone come across a way to import the contents of mbox files (10 megs or so) into MySQL?

Thanks, j

Answer 1

Not a complete answer, but to save you the heartache of parsing the mbox directly you could start with converting to Maildir. You can then take each file in the Maildir as a known single mail and easily parse/insert the contents.

mb2md will do this: http://batleth.sapienti-sat.org/projects/mb2md/ - I've used it before and it's pretty reliable IME.