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
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
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
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
Thanks John for mb2db.c
When i do the make i get compiling errors
Any idea where to look
Thanks
[EMAIL PROTECTED] dbmail]# make mb2db
cc -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCEmb2db.c -o mb2db
/tmp/ccb3yJbn.o: In function `main':
/tmp/ccb3yJbn.o(.text+0x3e): undefined reference to `confi
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,
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
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
I'm new to this list.
I saw when looking through the archives that Mark Mackay posted a fast
mbox to dbmail converter, however the archives don't support MIME, and I
can't decode the attachemnt. Can someone re-post it or tell me where I
can find it.
I am testing dbmail with a view to moving
