Is there any way to synchronize two MySQL databases that doesn't involve completely replacing one with the data from the other? i.e. suppose you make changes to two different databases (one online and one off) and then (when you connect) you want the changes to be reflected in both databases?

Thanks!