LOAD DATA LOCAL INFILE
To export big size csv(e.g 10gb) files in to mysql database using phpmyadmin is difficult task ,fortunately we have solution.You can use linux ssh prompt to insert big size csv files mysql database, for that we have MySQL function ” LOAD DATA LOCAL INFILE ” by using this we can insert big gb sql file in to database(export big size csv files in to database) directly, below we have mentioned syntax with example
# mysql -u admin -p`cat /etc/psa/.psa.shadow`;
mysql>LOAD DATA LOCAL INFILE ‘FileName.csv’ INTO TABLE table
FIELDS
TERMINATED BY ‘,’
LINES
TERMINATED BY ‘\\n’
IGNORE 1 LINES
(column1, column2, column3…)