MySQL - Copy Client Server 1 DB Tbl1 to Master Server 2 DB Tbl1

See more:

MySQL

Hello,


I would like to copy the data from one table to another between different servers.

If it is with in the same server and different databases, i have used the following

SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data)

INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data)

Now my question is copy the data from SERVER1 --> DB1--> TBL1 to SERVER2 --> DB2 -->TBL2



For example i deploy my VB.NET application together with MySQL Client Backend in 40 Client Work Stations on different places.

What i want to achieve here is make something like TRIGGERS or REPLICATE, Something like every client db queries such as (ADD,EDIT & DELETE) will be sent to a Master MySQL DB.

Honestly i havent done this before and it would be ,y first time using either REPLICATE ir TRGGER so i am not that aware of its respected use. But as some researches that i performed i have read that i need something like TRIGGERS that only problem here is that all seachers i have done pointed me from trigger where two tables are located in one SERVER.

Please help.