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
Jump to PostAre 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.
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.
Can something like this is doable
Insert Ignore INTO server3.db1.table1(select server1.db1.tbl1 union select server2.db1.tbl1)
I don't think this will work over (physically) different servers.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
