Christopher Bergeron writes:
> Does anyone know of any applications that insert email into mysql databases?
> I can use either Windows or Linux as the client; however, I want mysql
> server on the linux box (for stability). I don't like having all of my
> email in MSOutlook's proprietary format because in 5 years when I need to
> look back at something, I'll need a sql db search, not ms-outlooks little
> search algorithm (I get a lot of email daily).
>
> Anyone have any suggestions or recommendations??
Hi,
In every src and binary tarball distribution of MySQL there is a
script called 'mail_to_db.pl' in the 'tests/' subdirectory. This
script is exactly what you are looking for.
You can either pipe mails to it one by one as they come into your
system, or you can feed it mailbox files.
Matt
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor
/_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php