mysqldiff差异比较

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.

转载于:https://www.cnblogs.com/hxlasky/p/10723166.html