Not sure if this is the right place for this. I have a mysql server on two differnet machines on the same subnet. I would like to be able to transfer a single record from one database table on one machine to an identical table on the other machine based on some criteria (eg creation date). I have been looking at using something like mysqldump or outputing an xml file of the record. Looks like both are possible athough I have not determined the exact syntax for the script yet.
Just wanted to know if this is the best method or whether there is a better way of doing it ?
Some examples would be great.