Re: Fatal error encountered attempting to read the resultset.

[Fernando Gonzalez]

Hi,

The main problem is using 'ignore 1 lines' clause (which make load data skips the first row in the input file).
Something like this actually works:
LOAD DATA LOCAL INFILE 'D:\\src\\ForumIssues\\LoadDataInfile\\input.txt' INTO TABLE By_Switch FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\r\\n'

Also, in your create table defintion, the "Port" column definition is duplication, I commented out the first one.

To get an idea of the expected format, you can generate an input file with this couple of statements:

insert into By_Switch select 'BRCOL-CORE-A',0,'2000000533586F00',1,0,'9/17/12 8:45 PM',304,6527.82,24454.09,30981.9013,11.34,46.27,57.602,10.27,29.19,1.778,1.937,1.904,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.4,5.71,3.55,0.0,0.0,0.0,0.0
select * from By_Switch into outfile 'D:\\src\\ForumIssues\\LoadDataInfile\\output.txt'