List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:July 29 1999 2:19pm
Subject:Re: Importing mail files into mysql
View as plain text  
Wow, it was there all the time!  Thanks a million!!

-Graeme

----- Original Message -----
From: Jani Tolonen <jani@stripped>
To: Graeme B. Davis <GraemeD@stripped>
Cc: <mysql@stripped>
Sent: Thursday, July 29, 1999 6:26 AM
Subject: Re: Importing mail files into mysql


>
> On Wed, 28 Jul 1999, Graeme B. Davis wrote:
>
> > Does anyone know how I could easily import a /var/spool/mail or POP3
spool
> > into a mysql database that has to/from/subject/body fields?
> >
> > Any hints/ideas would be greatly appreciated.
> >
> > Thanks,
> >
> >
> > Graeme
>
> Hello Graeme,
>
> You have a perl script called 'mail_to_db.pl' in your
> "MySQL_distribution_directory/tests". It was included
> in 3.22 and 3.23. I can't remember when it was included
> for the first time, but in the newest versions of MySQL
> you can find it. It will do the job for you and has even
> more fields available than you need. I include in this
> mail also the dump of the table definition that is used
> by that script. You have also another perl script included
> in the same directory, called 'pmail'. You can use it
> for printing the mails in a shell. It is quite handy.
>
> Regards,
>
> - Jani
>
> +-------------------------------------------------------------+
> | TcX  ____  __     _____   _____  ___                        |
> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen     |
> |    /*/ /*/ /*/   \*_    |*|   |*||*|       jani@stripped   |
> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki         |
> |  /*/     /*/  /*/ \*_/*/ \*_ /*/ |*|_____  Finland          |
> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                   |
> |             /*/             \*\            Developers Team  |
> +-------------------------------------------------------------+
>
>
>


----------------------------------------------------------------------------
----


> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread8725@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

Thread
Importing mail files into mysqlGraeme B. Davis29 Jul
  • Re: Importing mail files into mysqlJani Tolonen29 Jul
    • Re: Importing mail files into mysqlGraeme B. Davis29 Jul