Re: [Dbmail] MySQL limit table size

2002-07-28 Thread Eelco van Beek
Hi Sam, You can also convert to postgresql. Just make dumps and use the mysql import tool. Postgresql can grow to 17 Tbyte table sizes. Best regards, Eelco On 28-07-2002 19:05, "Sam Przyswa" <[EMAIL PROTECTED]> wrote: > Jeff Brenton ([EMAIL PROTECTED]) écrivait: >> >> You can convert the e

Re: [Dbmail] MySQL limit table size

2002-07-28 Thread Sam Przyswa
Jeff Brenton ([EMAIL PROTECTED]) écrivait: > >You can convert the existing database (or, at least the message block >table) to innodb format, which will allow it to expand beyond 4gb. > >Information on doing this is in the MySQL documentation (barely!), but >there is a more extensive how-to on the

Re: [Dbmail] MySQL limit table size

2002-07-28 Thread Jeff Brenton
You can convert the existing database (or, at least the message block table) to innodb format, which will allow it to expand beyond 4gb. Information on doing this is in the MySQL documentation (barely!), but there is a more extensive how-to on the MySQL web site. Well, actually, it's on the innodb

[Dbmail] MySQL limit table size

2002-07-28 Thread Sam Przyswa
Hi, We use DBmail with Postfix for multiples domains and virtuals users in IMAP on Debian 2.4 kernel. The mail base is about 35000 messages and the messageblks table is more than 4Gb and MySQL say that it can't insert more records because the table is full. How to rise the table size limit, we

Re: [Dbmail] mbox2dbmail performance

2002-07-28 Thread Frido Ferdinand
Eelco, Thanks, thats a lot faster :) Conversion started @ Sun Jul 28 17:24:37 2002 Conversion finished @ Sun Jul 28 17:28:20 2002 I had to edit the file a little bit so that it inputs files into their respective mailboxes under one user. Also I had to edit: *mbox_delimiter_pattern = "^From .*

Re: [Dbmail] Several things- postfix's mailbox_transport, /etc/aliases, SpamAssasin

2002-07-28 Thread Jeff Brenton
Hello Eric, ER> What my concerns is, setting up dbmail to use nothing /but/ the dbmail for ER> dropboxes, completely removing the need for mbox formatted mail. I'd setup a ER> transport for my main domain, myrddincd.com to go through dbmail. And that ER> works great, for just that domain, but I