The most efficient way to do this is to do a mysql dump and pipe it to a mysql import
for e.g.
mysqldump --opt --quick --single-transaction --host=sourcehost -uuser -ppassword | mysql -h -uusername -ppassword
for e.g.
mysqldump --opt --quick --single-transaction --host=sourcehost -uuser -ppassword
No comments:
Post a Comment