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