Run from mysql program with FILE privileges or it won’t work.
LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);
Note: Path needs to be absolute
import CSV into MySQL
5th Sep 2009