Check this out
http://dev.mysql.com/tech-resources/articles/syncman/index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You may want to consider automating the synchronization of your databases
via replication. Check out the Replication chapter in the MySQL manual
(chapter 6 in the MySQL 5.0 manual).
I don't know if Replication can cope with changes to the table structure -
I've never played with Replication -