On 10/5/05, Claire Lee <[EMAIL PROTECTED]> wrote: > We have two clusters running the same data > independently and saving output to databases on two > systems (two hosts) respectively. We need to compare > the output each day. Is there an easy way to compare > tables from two systems? We are sure the structure of > the tables are all the same and we need to compare the > data. Any advice is welcome. Thanks.
mysqldump -l -B db1 > db1.sql mysqldump -l -B db2 > db2.sql diff db1.sql db2.sql > diff.sql -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/