Merging Two Tables in Different Servers to a Single Server

[dharmendra1986]

I have a database on both the servers with different table values and a
third server with the same named db and tables in MYSQL

server1-db1-table1

table1
ID Number
1 101
2 102
3 103

server2-db1-table1

table1

ID Number
4 201
5 202
6 303

How can I merge these two databases on a different server?
Like the desired result

server3-db1-table1

table1

ID Number
1 101
2 102
3 103
4 201
5 202
6 303

Thanks

[pritaeas]

Are you looking for a tool? For a tool I'd use Navicat (paid), but there's also Toad and Heidi, or you could just dump the tables and import them again using the mysql command line tools.

[dharmendra1986]

Can something like this is doable

Insert Ignore INTO server3.db1.table1(select server1.db1.tbl1 union select server2.db1.tbl1)

[pritaeas]

I don't think this will work over (physically) different servers.