Hi Niran,
See here: http://www.mysql.com/doc/en/Full_table.html
By default, with dynamic row length tables, MySQL only uses data
pointers large enough to address 4GB of data file. To have a data file >
4GB, you need to specify MAX_ROWS and AVG_ROW_LENGTH in CREATE/ALTER
TABLE (assuming your file system can handle files > 4GB):
ALTER TABLE your_table MAX_ROWS=10000000
AVG_ROW_LENGTH=1024;
The MAX_ROWS and AVG_ROW_LENGTH values don't matter as long as their
product is greater than 4,294,967,295.
Hope that helps.
Matt
----- Original Message -----
From: "Niran Angkawattanawit"
Sent: Sunday, November 16, 2003 7:14 AM
Subject: Problem about the maximum isze of MYISAM table
> Hi,
>
> I've found the problem about the maximum size of MYISAM table.
> The error occured while I'm trying to insert data into the table by
using
> "LOAD DATA" command.
> I got an error message like this:
>
> " ERROR 1114 at line 1 in file: 'table.list': The table
'table.list' is
> full "
>
> The maximum data size that MySQL insert into table is 4GB.
> However, I think the table size will be changed but I don't know
how to
> do.
>
> Everyone know how to fix this problem, please tell me.
> Thank you very much.
>
> Niran Angkawattanawit
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
