Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly observed that when in try to run this statement with
a file having 20,000 records.
The problems starts when records in the files are more then 20,262
"ERROR 1030: Got error 28 from table handler"
This is the error I get.
MySQL Version: 4.0.13
Host: Linux - Red Hat 7,0
Is this related to my sql global variables or hardware resources ?
Thanks in advance.
Regards,
Alpesh Kothari
Oracle DBA
Net4Nuts Limited
[EMAIL PROTECTED]