$ mysqldump --add-drop-table -h host1 db1 | mysql -h host2 db2