That's a small sql script to import a csv file without headers...just a bunch of data...I don't know why I had a trouble with the server when I tried other samples....

import_csv.sql

LOAD DATA local INFILE '/path/to/file.csv'
INTO TABLE name_scheme.name_of_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
IGNORE 0 LINES
(field1,field2,field3,field4);