MySQL database transfer from server to client
I want to transfer my one machine database to another machine.
开发者_如何学运维Whenever in my one machine(server) data is generated it must be transferred to another machine.
But if I delete data from my server the changes should not imply on the other machine.
Only insertion from server to client should be allowed no deletion from server to client should imply changes.
You should read some doc about triggers. Put some on INSERT and UPDATE events on the tables you need to backup.
精彩评论