You could try to use MERGE tables to get around this problem. Put all your data in several MyISAM tables and create a merge table on top of them.
Peter Sap. ----- Original Message ----- From: "Niran Angkawattanawit" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 16, 2003 2:14 PM 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]
