mysql not reading the whole file, skipping rows instead while using `load data local`

Question

In one of my assignment problem, I need to read an input file that has 131262 lines.

Following is my code for reading the input:

create table batsman_scored(
    id int(10) unsigned auto_increment primary key,
    match_id int(10),
    over_id int(10),
    ball_id int(10),
    runs_scored int(10),
    innings_no int(10)
);
load data local infile "data/batsman_scored.csv" 
into table batsman_scored
fields terminated by ','
lines terminated by '\n'
ignore 2 rows
;

The problem is, for some reason, MySQL is not reading the whole file, instead, it is getting terminated after few lines. I checked the input files, and there is nothing suspicious there. Mysql output:

Query OK, 568 rows affected, 65535 warnings (0.50 sec)
Records: 131260  Deleted: 0  Skipped: 130692  Warnings: 261952

Can someone tell, why it's skipping so many rows? When does MySQL skip rows?

I checked that MySQL can store a lot more than 568.

CSV data

Answer 1

I am still waiting for an answer here, but commenting the auto_increment line:

create table batsman_scored(
    // id int(10) unsigned auto_increment primary key,
    match_id int(10),
    over_id int(10),
    ball_id int(10),
    runs_scored int(10),
    innings_no int(10)
);
load data local infile "data/batsman_scored.csv" 
into table batsman_scored
fields terminated by ','
lines terminated by '\n'
ignore 2 rows
;