Again, this is really a note to myself, but here is a query to import CSV data on the server: -
LOAD DATA LOCAL
INFILE '<path_to_file>'
INTO TABLE `<table_name>` FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\n'
IGNORE 1 LINES
N.B. You have to make sure the structure is already in place.