How to compare two Mysql tables in different databases and update

Question

I have a c# asp.net 2.0 project, in which i'm using Mysql as backend. I'll have two databases, one in the remote web server and on in a local server. Both theses databases are identical. The manual changes will be made to the local database. i need to compare these tables with that of the remote database tables and update any matching rows and to insert any new rows. which is the best way to do this ?

Thank you for your time.