# mysqldump -h host.com  -u root -p password sourceDB | mysql -h host2.com -u username -p password -C targetDB

Interestingly, you don’t actually have be on the ‘source’ machine thanks to mySQL’s -h switch. From the target machine, simply specify the remote host after the -h. This was quite useful for me as my source machine didn’t have mysqldump installed.