Hello all, I wonder if you can help me? Background: I have two databases (on different machines). I have a requirement to move to having multiple slaves to do the queries involved, at the moment we have data on both machines and our apps choose the machine that has the necessary data to satisfy the specific query. Our initial goal was to upload the data to each machine so that they were in sync and that each machine could satisfy any query that was sent it's way, but over time (due to lack of 'disk space' / 'administrator laziness' / 'lack of planning on my part' / 'other stuff') the two databases have forked into separate roles.
My question is this: Is there anything out there that will report/resolve the differences between two databases and I'm not particularly talking about differences in table structure (a la mysqldiff etc..) but more like reporting on which tables are identical in 'Rows', 'Data_length', 'Index_length' etc. and which tables differ in 'Create_time' and 'Update_time' so that I can create a new DB to use as a master for replication with the confidence of knowing that it has our most up-to-date data in place. A famous man once said (of open source stuff) that "If you can think of it someone has already done it!" - I hope that's true in this case... I could only find scripts on the web that compare table structures - and not analysing the state of the data therein.. I don't feel like spending a several hours writing perl to do this task for me - can anyone help please? Cheers, Andrew Andrew Braithwaite Implementation Manager multimap.com t: +44 020 7430 5450 e: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
