Copy MySQL tables between different hosts [31]

The following command will allow you to copy MySQL tables between different hosts

mysqldump -h ip -uuser -ppass from_db from_table | mysql -uuser -ppass target_db