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

whahoo has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: What's the best way to copy LOTS! of records between 2 mySQL servers? by Russ (Deacon) on Aug 24, 2000 at 03:27 UTC
MySQL also has `SELECT * FROM skr INTO OUTFILE 'filename'; LOAD DATA INFILE "filename" INTO TABLE skr;` [download] 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	[reply] [d/l]
Re: What's the best way to copy LOTS! of records between 2 mySQL servers? by Anonymous Monk on Aug 23, 2000 at 15:24 UTC
mysqldump -u<username> -p<password> \ -h<remote_host> -c <databasename> \| mysql \ -u<localuser> -p<localpassword> newdatabase you may add --add-drop-table on the left side of the pipe if the database tables already exists locally and -C if you are on a slow connection (uses a compressed protocol for data tranfer)	[reply]