Porting Tables Between 2 MySQL Servers

[Vinodh Kumar]

Dear All,

I am working on a mysql module for my new assignment which requires me to port data from x server to y server.
Both X and Y are 2 different MySQL Server for which I have sufficient privileges for inserting data.
I have 2 tables in X - Source Server and same 2 tables created in Y - Designation Server with the same table structure.
Now, I should be able to port the data from X to Y for these 2 tables.

I was able to achieve this using Microsoft's SSIS Package - but I need to know whether we have any other tools available with MySQL to do it - with minimal tasks and complexity.

Any help on this would be much appreciated.

Thanks,
Vinodh