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 ?