Hi there,
I create a large table with the following command
CREATE TABLE MyTable( ID int unsigned not null, Description longtext, index(ID), foreign key (ID) references MainTable (ID) on delete cascade ); alter table MyTable max_rows = 20000000000;
Then if I do "show create table" statement, it shows "MAX_ROWS=4294967275".
Then when I tried to load a data file with 10814572 records, it stops after loading 5081016 records and gave the "Table is full" message.
However, if I change the Description column from largetext to text, I can successfully load into all those records. Any idea why?
Here is my server info
$ uname -a
Linux machinename 2.4.21-9.0.3.ELsmp #1 SMP Tue Apr 20 19:49:13 EDT 2004 i686 i686 i386 GNU/Linux
MySQL version is 4.1.8-standard
Thanks!
Qunfeng
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]