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
asked Jan 20, 2015 at 19:33
Add a comment
|
1 Answer
"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.
