in reply to What's the best way to copy LOTS! of records between 2 mySQL servers?
MySQL also has
The MySQL team says this is a very fast way to copy data from one server to another.SELECT * FROM skr INTO OUTFILE 'filename'; LOAD DATA INFILE "filename" INTO TABLE skr;
Check the MySQL Manual for more info.
Russ
|
---|
In Section
Seekers of Perl Wisdom