I took a back up of my production server and created new server few weeks before. I want to move some transactional data from my production to the backup server.what is the best way to do this?.
4
-
Possible duplicate of MySQL - Move everything to a new serverNico Haase– Nico Haase2018-01-17 08:29:08 +00:00Commented Jan 17, 2018 at 8:29
-
i don't wan't to move everything i just want to move some transactional data.this contains many tables. using postgres/oracle i was having an option to connect to other db via db link.Shamseer Pc– Shamseer Pc2018-01-17 08:35:59 +00:00Commented Jan 17, 2018 at 8:35
-
How should your application work if some data is here and some is there? Are you looking for a master/slave setup?Nico Haase– Nico Haase2018-01-17 08:50:51 +00:00Commented Jan 17, 2018 at 8:50
-
No. One of client moved to new environment so they are still having some data in my old production environment .Shamseer Pc– Shamseer Pc2018-01-17 09:22:55 +00:00Commented Jan 17, 2018 at 9:22
Add a comment
|
1 Answer
Your question is not very clear, it's hard to understand what you want to move and where (you are talking about "old production", "new production", and "backup" servers, I don't understand which is which).
Anyway, there is no db link in MySQL. However you could have a look at the FEDERATED storage engine which will allow you to connect to a table on old server from the new server. Then run the insert/update/delete queries on the new server to move the data.
