How to export big size csv files mysql database

LOAD DATA LOCAL INFILE 

To export big size csv(e.g 10gb) files in to mysql database using phpmyadmin is difficult . 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 i 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…)

see more about SSH

Leave a Reply

Your email address will not be published. Required fields are marked *