3

I am looking for a program that can convert .mbox files to .sql (or directly insert .mbox data into some database). It should run on Windows or Linux.

If possible:

  • Gratis
  • Open source
  • can handle large .mbox files

1 Answer 1

3

"Free and open source" - given that requirements, I guess your best shot is to create a small Perl script, utilizing the modules Mail::Mbox::MessageParser and SQL::Generator. For Python, the module "mailbox" might be of use, as well as the mogrify function from Psycopg. Should not be too hard for someone with >5K points at Stackoverflow.

If you are looking for a solution where you don't have to program anything, forget "free and open source". Google for "read mbox excel", that will bring you to some commercial solutions to import mbox into an Excel sheet. You will surely find canned solutions to insert Excel sheets into the database of your choice.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.