Hi Paul, On Jan 16, 2008 12:19 PM, Paul Berry <[EMAIL PROTECTED]> wrote: > hi there, sorry if this email doesn't follow policy correctly, its my first > post here. > > we had a master/slave setup between 2 servers and 98% of the data seems to > have moved correctly, but there is a seemingly random 2% that didn't arrive > in the right way. for example records with a higher ID are there and some > with a lower IDs are missing > > concrete question is > > is there an excellent linux tool or method that allows for comparing missing > records and moving just those?
Yes. Maatkit: http://maatkit.sourceforge.net/ The short and sweet: mk-table-checksum with --replicate on the master, then mk-table-sync to correct the differences. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]