import CSV into mysql

LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','

Export a table on MySQL

select * into outfile '/tmp/outfile.txt' fields terminated by ',' from my_table_name;