Andrew, could Jon Frisby's datadiff
http://freshmeat.net/projects/datadiff/?topic_id=66%2C822%2C836%2C861 help here? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query ----- Original Message ----- From: "Andrew Braithwaite" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, November 28, 2002 4:41 AM Subject: comparing two databases in readiness for implementing replication > 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 > --------------------------------------------------------------------- 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