MyISAM tables can be larger than 4Gb without using merge tables. This topic has been discussed several times on this list. You will find all details in "Google groups" archive: http://groups.google.com/groups?q=myisam+4Gb+limit+group:mailing.database.mysql&scoring=d
Hope this helps, Joseph Bueno
Peter Sap wrote:
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]
