I'm going to write a python script that copies some of the tables in a MySQL database from one remote machine(remote1) to another database on another remote machine(remote2) everyday.
What's the most convenient way to do this?
Because the two tables are on different machines, the following MySQL command doesn't work.

CREATE TABLE newtable LIKE oldtable; 
INSERT newtable SELECT * FROM oldtable;

Currently, my idea is:

Read the table schema of srcTable on remote1. Create the table on remote2.
Run SELECT * FROM theTable; on remote1. Save the result into a variable.
Run INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...); on remote2 using the values in the variable.

Is there any better solution which is simpler?
single command for Export & Import:
/opt/lampp/bin/mysqldump -u root -ppass bd_name table_name_optional | ssh root@192.168.3.252 /opt/lampp/bin/mysql -u root -ppass db_name
Two step: first export by below command:
/opt/lampp/bin/mysqldump -u user-ppass db_name [table name separated by space  -optional] > /opt/db_backup/db_name.sql

second command for import:
/opt/lampp/bin/mysql -u user-ppass db_name < /opt/db_backup/db_name.sql
Hope help you.
Best way to copy mysql tables from a remote machine to another