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
Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. It only takes a minute to sign up.
Sign up to join this community"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.