SELECT * FROM dump_table INTO OUTFILE "/tmp/dump.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';"
LOAD DATA LOCAL INFILE '/tmp/dump.csv' INTO TABLE dump_table2 FIELDS TERMINATED BY ',' ENCLOSED BY '"';
CREATE TABLE tbl_a AS SELECT * FROM tbl_b;