in reply to How to synchronize two database tables in MySQL?

What you need is a routine that takes the set of incremental changes from version x to version y (a la Cap'n Steve's suggestion) and merges them into one set of changes. This is probably much easier than trying to interpret changes based on table definitions alone.
  • Comment on Re: How to synchronize two database tables in MySQL?