mysql -e 'SELECT * FROM table' > out.txt

load data local infile 'out.txt' into table 'some_table'