Re: [Dbmail] mbox to dbmail converter

2002-12-18 Thread Jacques-Beaudoin
Thanks John mb2db as compiled ok and i got all my folders in mysql i think it was the part about build.sh mb2db sould be included in dbmail and always compiled with the dbmail programs (dbmail-smtp,dmail-pop3detc) Jacques

Re: [Dbmail] mbox to dbmail

2002-12-18 Thread
Hi, the fastest way to import data is to use a "LOAD DATA INFILE" statement in mySQL (for postgresql, use "COPY FROM"). This will bypass a lot of overhead. Be sure to remove all indices and all the restraints you can for they as well take time. Just add them afterwards, it is a lot faster to

Re: [Dbmail] mbox to dbmail

2002-12-18 Thread John Heller
The plan is to use mysql. Eelco van Beek - IC&S wrote: Hi, We once wrote a program to insert 10 Gb of mail into dbmail. The program did this in about 50 minutes. What database are you going to use? Best regards, Eelco

Re: [Dbmail] mbox to dbmail converter

2002-12-18 Thread John Heller
Jacques, Your make does not appear to be pulling in all of the objects on the command line. Check the definition of UNIONE_OBJECTS, DIRS and LIB in the Makefile. You need to have run build.sh first to generate the proper Makefile. Its probably better to put the lines I suggested in Makefile.c

Re: [Dbmail] mbox to dbmail

2002-12-17 Thread
Hi, We once wrote a program to insert 10 Gb of mail into dbmail. The program did this in about 50 minutes. What database are you going to use? Best regards, Eelco On dinsdag, dec 17, 2002, at 06:39 Europe/Amsterdam, John Heller wrote: Jacques, I have about 50GB of user's mail to transfer,

Re: [Dbmail] mbox to dbmail

2002-12-17 Thread John Heller
Jacques, I have about 50GB of user's mail to transfer, so using scripts based on formail and dbmail-smtp is too slow to be practical. Also this does not set the seen and answered flags correctly. All mail appears as unread. I found the previously posted code from Mark Mackay (mbox2dbmail-fast

Re: [Dbmail] mbox to dbmail

2002-12-13 Thread Jacques-Beaudoin
Hi John I wrote a script to convert mbox to dbmail give it a try and let me now if it works for you. This script as 5 sections and sections-3 (hierachical folder) neads a modified dbmail-smtp to work correctly. Maby you can help me in having dbmail-smtp modified by the dbmail team. Thanks Jacq