[root@ollie ~]# ./find_table_diffs.pl -d dsstats_sp_raw -h db1-ds.lad.internal -s db2-ds.lad.internal -u systems
password:
Tables in database dsstats_sp_raw with mismatched rows
TABLE: db1-ds.lad.internal vs db2-ds.lad.internal
raw_load_2007_09_09: 12400632 vs 6507302
raw_search_2007_08_08: 7950543 vs 4100252
raw_search_2007_09_03: 7669473 vs 3908804
raw_visit_2007_08_19: 15665574 vs 7352499
raw_visit_2007_08_30: 8534125 vs 18145557
raw_visit_2007_09_04: 8720186 vs 18479086
raw_visit_2007_09_07: 8440646 vs 17980656
[root@ollie ~]# ./find_table_diffs.pl -d dsstats_sp_raw -s db1-ds.lad.internal -h milo.ds.internal -u systems
password:
Tables in database dsstats_sp_raw with mismatched rows
TABLE: milo.ds.internal vs db1-ds.lad.internal
raw_visit_2007_08_30: 18145557 vs 8534125
raw_visit_2007_09_07: 17980656 vs 8440646
[root@ollie ~]# ./find_table_diffs.pl -d dsstats_sp_raw -s db1-ds.lad.internal -h major.ds.internal -u systems
password:
Tables in database dsstats_sp_raw with mismatched rows
TABLE: major.ds.internal vs db1-ds.lad.internal
raw_search_2007_08_25: 3720871 vs 7223224
raw_search_2007_08_27: 4255715 vs 8274625
raw_visit_2007_08_30: 18145557 vs 8534125
raw_visit_2007_09_04: 18479086 vs 8720186
raw_visit_2007_09_07: 17980656 vs 8440646
[root@ollie ~]# ./find_table_diffs.pl -d dsstats_sp_raw -s db1-ds.lad.internal -h peon1.lad -u systems
password:
Tables in database dsstats_sp_raw with mismatched rows
TABLE: peon1.lad.internal vs db1-ds.lad.internal
raw_load_2007_09_04: 13800836 vs 13800841
raw_visit_2007_09_04: 18479086 vs 8720186