Unanswered: Transfer data from multiple mysql server
i have situation for transfering data or update from multiple mysql server in different location to one mysql server. what i want to do it is, when user update record or create new record in own mysql server than that data will be automatically updated/copy to one mysql server.
do you guys have any idea how can i implement this or where can i find example.script or anything related.
is that i need create mysql script using batch mode..or ?