mysqldump database_name_1 \
--host=address_1 \
--port=3306 \
--user=username_1 \
--password=password_1 \
--single-transaction \
--compress \
--no-create-db \
--skip-add-locks \
--skip-comments | mysql \
--host=address_2 \
--port=3306 \
--user=username_2 \
--password=password_2 database_name_2