http://www.perlmonks.org?node_id=29354


in reply to What's the best way to copy LOTS! of records between 2 mySQL servers?

MySQL also has
SELECT * FROM skr INTO OUTFILE 'filename'; LOAD DATA INFILE "filename" INTO TABLE skr;
The MySQL team says this is a very fast way to copy data from one server to another.

Check the MySQL Manual for more info.

Russ