I have a project where I have to sync a local mysql db with a hosted remote one.
The local mysql db is on a usb stick and runs on a portable web server. If any changes are made to the remote, hosted (master) db, these changes should reflect to the local (slave) db with an update script (preferably php). If possible, only updated, changed, newer entries should be synchronised.
Ever done this? Any ideas how I should approach this issue?