分享技术,记录生活,在互联网上留下属于自己的一亩三分地。

Centos7安装mysqldiff

默认笔记 novadmin 349℃ 0评论

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.

 

转载请注明:Nov » Centos7安装mysqldiff

喜欢 (0)or分享 (0)
发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址