Hi,

I am having a file dump3.txt like this:-

919814103820 |
919592967609 |
919781034217 |
918198817264 |
918872196136 |
919855523943 |
.....

I have a Database table TEST_PARTITION. Below is its structure:-
mysql> show create table TEST_PARTITION \G;
*************************** 1. row ***************************
Table: TEST_PARTITION
Create Table: CREATE TABLE `test_partition` (
`MSISDN` bigint(20) NOT NULL,
PRIMARY KEY (`MSISDN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.11 sec)


I am trying to insert the data from dump3.txt into this table using below command :-

mysql>
mysql>
mysql> LOAD DATA LOCAL INFILE "dump3.txt" INTO TABLE TEST_PARTITION (MSISDN);


But, Data is not getting populated. The command is never ending.. It is running and running and running/......

Please help !

Aditya