Wednesday, March 21, 2012

Copy Table from One Server to Another in MYSQL

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

No comments:

Post a Comment