Best solution to sync two tables

[zrinyi]

Hi,
what is the best way to sync two tables (call it local and remote)?
I would like a solution that replaces a registry if the local is different of the remote one. And insert the registry if it doesn't exist on the local table.
Is there any smart solution for this?
Thank you in advance!
István

[kklosson]

I would consider doing this with an external tool. For example, Navicat has a synchro capability and I image other tools such as MySQL Workbench do as well.

[zrinyi]

Hi kklosson,
thank you for the suggestion!
I will check MySQL Workbench possibilities.
Regards, Istvan