Make sure that your primary key for the table is of type unsigned bigint, which is the largest possible auto sequential index type that can have a value up to 18446744073709551615. The limit is also dictated by the file-system on which your MySQL database binary file is stored. If you are running Linux, make sure you have the latest generation of ext (currently ext4) file-system formatted partition holding your MySQL database file (/var/mysq/data/ for example).

A possible reason why your Input attempt is failing could be a file size limit on your Windows partition, but I can't say for sure.

create table cash_order(Record_Indicator char(2) not null, Segment char(4) not null,Order_number bigint unsigned not null, Transaction_Times bigint not null, Buy_Sell_Indicator char(1) not null, Activity_Type Int(1) not null,Symbol varchar(10) not null, Series char(2) not null, Volume_Disclosed int unsigned not null,Volume_Original int unsigned, Limit_Price int unsigned, Trigger_Price int unsigned, Market_Order_Flag char(1) not null,Stop_Loss_Flag char(1) not null, IO_Flag char(1), Algo_Indicator int(1), primary key(Order_number,Buy_Sell_Indicator,Symbol))max_rows=5000000000;

mysql> load data local infile '/media/Storage/cash_order.csv' into table cash_order fields terminated by ',' lines terminated by '\n';

Query OK, 9868890 rows affected, 65535 warnings (26 min 52.93 sec)

Records: 142316285 Deleted: 0 Skipped: 132447395 Warnings: 142316285

I am using  ubuntu 14 latest version. I checked format of file system it is ext4

I tried with small fize also it is still skipping records why it is skipping.

mysql> load data local infile '/media/Storage/cash_order_1.csv' into table cash_order_1 fields terminated by ',' lines terminated by '\n';

Query OK, 103050 rows affected, 65535 warnings (1.52 sec)

Records: 542563 Deleted: 0 Skipped: 439513 Warnings: 542571

I took all not null constraints, kept only order_number as primary kery and also same result.

but still i am not getting. please help me.

First, try to optimize your table's schema according to comments and suggested changes in this fiddle http://sqlfiddle.com/#!2/9bd7c/1/0 I've made for you.

Could it be that there is more than one record with the SAME combination of order_number, buy_sell_indicator and symbol in your CSV? I guess that the order number should be unique, but you should make sure that this is not the reason for failure.

Also, it says that there are warnings. Could you list some of the warnings in the SQL error log for me to see. Maybe there is some info that could help us find the problem.

Thank you very much Milan. I added transaction time to the primary key. now it is working

Great. So it was a duplicate record problem. :)