Simple MySQL export/import Posted on February 25, 2010 by linchear mysql -e 'SELECT * FROM table' > out.txt load data local infile 'out.txt' into table 'some_table'