Fastest way to insert data into mysql from csv I have a dataset of 233,902,846 rows in a csv file. 
I want to load the data into mysql table. What is the most efficient way of transferring the data so that data insertion is the fastest. actually simple mysqlimport will take around 4-5 days for the complete insertion.

Regards
Mona
I would normally use the following statement:

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\Users\\Desktop\\nameoffile.csv' REPLACE INTO TABLE `tmp_table` CHARACTER SET latin1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';


You should take a look at this page too.
http://derwiki.tumblr.com/post/24490758395/loading-half-a-billion-rows-into-mysql