Perl Monk, Perl Meditation | |
PerlMonks |
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 ( [id://29180]=note: print w/replies, xml ) | Need Help?? |
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)
In Section
Seekers of Perl Wisdom
|
|