RE: Table size limitations...

2001-08-15 Thread Trevor Linton
I'm not an SQL expert but if FreeBSD supports 4GB files than you should check your MAX_DATA_LENGTH properties on the table you're using. You can do this by running SHOW TABLE STATUS on the table. I believe you can use ALTER (or on create table statements) to change this value. Hope this helps,

Re: Table size limitations...

2001-08-15 Thread ryc
Look into MAX_ROWS... ie: alter table mytable max_rows = 1 ryan - Original Message - From: Nathanial Hendler [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, August 15, 2001 12:19 PM Subject: Table size limitations... I have a table that holds a lot of

Re: Table size limitations...

2001-08-15 Thread Dan Nelson
In the last episode (Aug 15), Nathanial Hendler said: I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The

Re: Table size limitations...

2001-08-15 Thread Nathanial Hendler
On Wednesday 15 August 2001 11:30, Dan Nelson wrote: In the last episode (Aug 15), Nathanial Hendler said: I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at