Re: [Dbmail] MySQL limit table size

2002-07-30 Thread Sam Przyswa
Eelco van Beek ([EMAIL PROTECTED]) écrivait: > >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. Ok, thanks but we want to stay with MySQL at this time, we try Innodb to fix this. Sam. -- Sam Przyswa - C

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