Export and import mysql to and from csv file on command line

Exporting mysql data to csv file on command line.

mysql --comments -uUSER -p -hHOST DBNAME -e "SELECT * FROM tablename INTO OUTFILE '/tmp/filename.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';"


Importing mysql data from csv file.

mysql --comments -uUSER -p -hHOST DBNAME -e "LOAD DATA LOCAL INFILE '/tmp/filename.csv' INTO TABLE tablename FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';"