How to import really huge CSV files very fast in one shot in remote MYSQL database server?

How to import really huge CSV files very fast in one shot in remote MYSQL database server? SOLUTION: Load Data command on MySQL LOAD DATA command in MySQL is a very fast & reliable way to import a huge CSV (containing several millilon lines/rows) to a remote MySQL server. Here is the syntax: LOAD DATA