kklosson Yes but now I am thinking that if AwareIM drops a column, then creates it, as it has done in the past, that this function won't perceive it.
hpl123 How about data loss/data "mismatch", can't NaviCat pick up at all on that when doing the syncronization?
hpl123 Found a free tool that actually compare both structure and data and this tool could maybe be used in the same way you did kklosson (i.e. compare after changes). http://www.percona.com/software/percona-toolkit Here is another link with a couple of other tools and some are commercial but there are possble other free tools here. http://stackoverflow.com/questions/225772/compare-two-mysql-databases PS: If anyone finds a working solution for compare etc please share your findings.
hpl123 hpl123 wroteFound a free tool that actually compare both structure and data and this tool could maybe be used in the same way you did kklosson (i.e. compare after changes). http://www.percona.com/software/percona-toolkit Here is another link with a couple of other tools and some are commercial but there are possble other free tools here. http://stackoverflow.com/questions/225772/compare-two-mysql-databases PS: If anyone finds a working solution for compare etc please share your findings. The following tool seems to be ideal for our purposes or at least in uncertain scenarios when doing changes on existing configurations (all tables i.e structure on both DB's has to match). It's a simple command line "action" and it compares master-slave DATA only (checksum check) and my thought is it's possible to A) copy DB before AIM changes , B) run this tool to compare data checksum and if it differs AT ALL restore BSV and DB backup and try again. Thoughts? http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html
