DanBrother的部落格

Export Table Data:
mysql -utest_usr -p"xxx"-h127.0.0.1 -P3306 -e "select * from test_usr.test_table where flag = 1" > test_usr.test_table.txt 2>/dev/null

Import Table Data:   (ignore first row column name)
mysql> LOAD DATA LOCAL INFILE '/home/mysql/test_usr.test_table.txt' INTO TABLE my_new_test_table IGNORE 1 LINES;

PS.

For csv file, import table data command (without column name in the first row):
mysql>  LOAD DATA LOCAL INFILE '/home/mysql/test_usr.test_table.csv' INTO TABLE my_new_test_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';