Fai quest'altra prova.

LOAD DATA LOCAL INFILE '/percorso_completo_del_file' INTO TABLE `tua_tabella` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'