It could well be there is a message in there the system cannot parse but you might check that the max_allowed_packet = entry in "my.cnf" supports the maximum size of packet you need to send to the server.
I have never used these scripts for migrating flat-file mail but I would imagine there is a descendency of passed error messages which prevents getting the whole story on the console. Have you checked the mysql error log? Syslog? Maillog? Your my.cnf should be in /etc but could be in your database namespace. It is possible that with a mailbox as large as 1gigabyte, there are individual messages which are quite large and therefore comprising an oversized packet based on your system settings. If you have enough memory, raise this value to 16-32m or more. You can also do this from the command line with set global max_allowed_packet=16777216; good luck... Mike ----- Original Message ----- From: "Lorna Sanchez M." <[EMAIL PROTECTED]> To: "DBMail mailinglist" <[email protected]>; "Paul J Stevens" <[EMAIL PROTECTED]> Sent: Sunday, April 17, 2005 9:37 AM Subject: [Dbmail] Re: mailbox2dbmail does not work for big inboxes? Hello! Yesterday I was making some tests on the data, and I splitted it in two, so more or less it will insert the first half first and then the second one. But I got the same error at the same point, so I guess is not mysql but my file that has some kind of "mistake". Has anybody got a "Mail parsing error" when migrating with mailbox2dbmail? I'm trying to locate what triggers the error in the file. If anyone has an idea of what's causing this error, you are most welcome to reply!!! :) Thanks! Lorna. On 4/16/05, Lorna Sanchez M. <[EMAIL PROTECTED]> wrote: > Hello! > > A friend and I are using dbmail, and we have to migrate > HUGE inboxes, > around 1GB each. We used the mailbox2dbmail with success > to migrate > other accouts below 600M but for accounts above or so, we > have the > "Error parsing mail" error. > The curious thing is that we get that error around the > 10,000 or > 11,000 line (each one of us is migrating a different HUGE > inbox). > > Is there a problem with insertions in mysql? Does mysql > has a limit? > I'm not convinced that my inbox file has a problem. > > This is the line I'm using: > ./mailbox2dbmail -u user -t mbox -m /var/mail/user -b > Inbox -p > /usr/local/sbin/dbmail-smtp > > Thanks a lot for the help! > > Lorna. > _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
