1.安装mysql-utilities
[root@localhost soft]# yum install mysql-utilities.noarch
2.比较数据库zentao和数据库db_zentao的差异
[root@localhost soft]# mysqldiff --server1=root:yeemiao1117@192.168.1.130 --server2=root:yeemiao1117@192.168.1.130 --difftype=sql zentao:db_zentao
# server1 on 192.168.1.130: ... connected.
# server2 on 192.168.1.130: ... connected.
# WARNING: Objects in server1.zentao but not in server1.db_zentao:
# TABLE: zt_im_message
# TABLE: zt_testsuite
# TABLE: zt_testreport
# TABLE: zt_webhook
# TABLE: zt_suitecase
# TABLE: zt_userview
# TABLE: zt_notify
# TABLE: zt_score
# TABLE: zt_im_chat
# TABLE: zt_im_messagestatus
# TABLE: zt_im_chatuser
# TABLE: zt_entry
# TABLE: zt_log
# WARNING: Objects in server1.db_zentao but not in server1.zentao:
# TABLE: zt_mailqueue
Compare failed. One or more differences found.