How to upload a large file through phpmyadmin in MySQL?
It is the best way to upload large CSV files through the LOAD DATA command.
Syntax:
LOAD DATA LOCAL INFILE "your file name"
INTO TABLE table name
FIELDS TERMINATED by ’,’
LINES TERMINATED BY ’\n’