• From: Cochituate, MA
  • Registered: 2009-01-21
  • Posts: 258

Topic: import email into MySQL database?

I'm looking to import hundreds of email messages stored in mbox format into a MySQL database. Is there a tool out there to do this already? I'd rather not reinvent the wheel if at all possible. I've been using HyperMail to archive my email in HTML format, but the results aren't searchable. I figure that once it's all in MySQL I can write some simple queries to accomplish this.

Thanks in advance...

extraspecialbitter's Website

  • benj1
  • Wiki Wizard
  • Offline
  • From: Yorkshire, England
  • Registered: 2009-09-05
  • Posts: 1,084

Re: import email into MySQL database?

dbmail can import mbox emails I believe

another option could be to write your own script, mbox is a pretty simple format, so shouldn't be too hard

- - - - - - - - Wiki Pages - - - - - - -
#! install guide           *autostart programs, modify the menu & keybindings
configuring Conky       *installing scripts
  • From: Cochituate, MA
  • Registered: 2009-01-21
  • Posts: 258

Re: import email into MySQL database?

@benj1 - thanks for the reply.  I've installed dbmail - which is in the #! repo - and am now wrestling with the mailbox2dbmail utility to convert from mbox to dbmail format.

extraspecialbitter's Website