mysqldbcompare --server1=mysqladmin:password1@10.10.1.20:3306 --server2=mysqladmin:password2@10.10.1.159:3306 db3:db3 --run-all-tests --changes-for=server1 --show-reverse --difftype=sql # WARNING: Using a password on the command line interface can be insecure. # server1 on 10.10.1.20: ... connected. # server2 on 10.10.1.159: ... connected. # Checking databases db3 on server1 and db3 on server2 # # Defn Row Data # Type Object Name Diff Count Check # ------------------------------------------------------------------------- # TABLE mmcers_adminreqstatus_t pass pass - # - Compare table checksum pass # TABLE mmcers_asset_m pass pass - # - Compare table checksum pass # TABLE mmcers_assetcategory_m pass pass - # - Compare table checksum pass # TABLE mmcers_assetemployee_m pass pass - # - Compare table checksum pass # TABLE mmcers_bccconfig_m pass pass - # - Compare table checksum pass # TABLE mmcers_bhrclosure_t pass pass - # - Compare table checksum pass # TABLE mmcers_confidcomment_t pass pass - # - Compare table checksum pass # TABLE mmcers_country_m pass pass - # - Compare table checksum pass # TABLE mmcers_designation_m pass pass - # - Compare table checksum pass # TABLE mmcers_designationorder_t pass pass - # - Compare table checksum pass # TABLE mmcers_district_m pass pass - # - Compare table checksum pass # TABLE mmcers_division_m pass pass - # - Compare table checksum pass # TABLE mmcers_emailtemplate_m pass pass - # - Compare table checksum pass # TABLE mmcers_empassetlevel_t pass pass - # - Compare table checksum pass # TABLE mmcers_emplevel_t pass pass - # - Compare table checksum pass # TABLE mmcers_employee_m pass pass - # - Compare table checksum pass # TABLE mmcers_employeeassetcatmap_t pass pass - # - Compare table checksum pass # TABLE mmcers_employeebusinessmap_t pass pass - # - Compare table checksum pass # TABLE mmcers_employeedivisionmap_t pass pass - # - Compare table checksum pass # TABLE mmcers_employeetype_m FAIL pass - # - Compare table checksum pass # # Transformation for --changes-for=server1: # ALTER TABLE `db3`.`mmcers_employeetype_m` AUTO_INCREMENT=19433; # # Transformation for reverse changes (--changes-for=server2): # # ALTER TABLE `db3`.`mmcers_employeetype_m` # AUTO_INCREMENT=359495; # # TABLE mmcers_empregionlink pass pass - # - Compare table checksum pass # TABLE mmcers_emptypeeditable_t pass pass - # - Compare table checksum pass # TABLE mmcers_forgetpassword pass pass - # - Compare table checksum pass # TABLE mmcers_functionalgroup_m pass pass - # - Compare table checksum pass # TABLE mmcers_grade_m pass pass - # - Compare table checksum pass # TABLE mmcers_gradedesigmap_t pass pass - # - Compare table checksum pass # TABLE mmcers_inductiontmp_m pass pass - # - Compare table checksum pass # TABLE mmcers_jobnature_m pass pass - # - Compare table checksum pass # TABLE mmcers_jobresponsibility_m pass pass - # - Compare table checksum pass # TABLE mmcers_onholdcommentviewers_t pass pass - # - Compare table checksum pass # TABLE mmcers_qualification_m pass pass - # - Compare table checksum pass # TABLE mmcers_qualificationorder_t pass pass - # - Compare table checksum pass # TABLE mmcers_region_m pass pass - # - Compare table checksum pass # TABLE mmcers_reminder_t pass pass - # - Compare table checksum pass # TABLE mmcers_remindermail_m pass pass - # - Compare table checksum pass # TABLE mmcers_report_t pass pass - # - Compare table checksum pass # TABLE mmcers_reportfield_m pass pass - # - Compare table checksum pass # TABLE mmcers_reportsearch_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqassetcomments_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqassetemployee_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqassets_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqassetstatus_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqclosecomment_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqcomments_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqdetails_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqinduction_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqjoiningdetails_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqmentnature_m pass pass - # - Compare table checksum pass # TABLE mmcers_reqonhold_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqpositions_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqqualification_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqskills_t pass pass - # - Compare table checksum pass # TABLE mmcers_reqstatus_t pass pass - # - Compare table checksum pass # TABLE mmcers_request_m pass pass - # - Compare table checksum pass # TABLE mmcers_requestwhomlink_t pass pass - # - Compare table checksum pass # TABLE mmcers_role_m pass pass - # - Compare table checksum pass # TABLE mmcers_rolelevel_t pass pass - # - Compare table checksum pass # TABLE mmcers_rolereport_m pass pass - # - Compare table checksum pass # TABLE mmcers_sapcompany_m FAIL pass - # - Compare table checksum pass # # Transformation for --changes-for=server1: # ALTER TABLE `db3`.`mmcers_sapcompany_m` AUTO_INCREMENT=182; # # Transformation for reverse changes (--changes-for=server2): # # ALTER TABLE `db3`.`mmcers_sapcompany_m` # AUTO_INCREMENT=414; # # TABLE mmcers_sapcompdivisionmap_t FAIL pass - # - Compare table checksum pass # # Transformation for --changes-for=server1: # ALTER TABLE `db3`.`mmcers_sapcompdivisionmap_t` AUTO_INCREMENT=35913; # # Transformation for reverse changes (--changes-for=server2): # # ALTER TABLE `db3`.`mmcers_sapcompdivisionmap_t` # AUTO_INCREMENT=41539; # # TABLE mmcers_sapdivision_m FAIL pass - # - Compare table checksum pass # # Transformation for --changes-for=server1: # ALTER TABLE `db3`.`mmcers_sapdivision_m` AUTO_INCREMENT=680319; # # Transformation for reverse changes (--changes-for=server2): # # ALTER TABLE `db3`.`mmcers_sapdivision_m` # AUTO_INCREMENT=800901; # # TABLE mmcers_sapemployee_m FAIL pass - # - Compare table checksum pass # # Transformation for --changes-for=server1: # ALTER TABLE `db3`.`mmcers_sapemployee_m` AUTO_INCREMENT=6725052; # # Transformation for reverse changes (--changes-for=server2): # # ALTER TABLE `db3`.`mmcers_sapemployee_m` # AUTO_INCREMENT=6831000; # # TABLE mmcers_search_m pass pass - # - Compare table checksum pass # TABLE mmcers_skill_m pass pass - # - Compare table checksum pass # TABLE mmcers_skillfuncdesig_t pass pass - # - Compare table checksum pass # TABLE mmcers_state_m pass pass - # - Compare table checksum pass # TABLE mmcers_team_m pass pass - # - Compare table checksum pass # TABLE mmcers_teammembers_m pass pass - # - Compare table checksum pass # TABLE mmcers_vertical_m pass pass - # - Compare table checksum pass # VIEW rpt_st pass - - # VIEW rpt_st_extended pass - - # VIEW rpt_st_pivot pass - - # Database consistency check failed. # # ...done