mysqldiff比较数据库之间差别

最新推荐文章于 2024-09-12 08:02:02 发布

Empty-Filled

最新推荐文章于 2024-09-12 08:02:02 发布

阅读量963

点赞数

分类专栏：测试

本文链接：https://blog.csdn.net/lylfv/article/details/90208637

版权

测试专栏收录该内容

49 篇文章 2 订阅

订阅专栏

比较数据库

mysqldiff --server1=root:pass@192.168.1.xxx:3306 --server2=root:pass@192.168.1.xxx:3306 db1:db2
# WARNING: Using a password on the command line interface can be insecure.
# server1 on 192.168.1.xxx: ... connected.
# server2 on 192.168.1.xxx: ... connected.
# WARNING: Objects in server1.iot_brain but not in server2.db2:
#        TABLE: bi_report
#        TABLE: event_record
#        TABLE: bind
#        TABLE: bi_report2
# WARNING: Objects in server2.iot3 but not in server1.db1:
#        TABLE: device_copy
Compare failed. One or more differences found.

比较表

mysqldiff --server1=root:pass@192.168.1.xxx:3306 --server2=root:pass@192.168.1.xxx:3306 db1.table1:db2.table2 --skip-table-options
# WARNING: Using a password on the command line interface can be insecure.
# server1 on 192.168.1.xxx: ... connected.
# server2 on 192.168.1.xxx: ... connected.
# Comparing db1.table1 to db2.table2            [PASS]
# WARNING: Table options are ignored and differences were found:
# --- idb1.table1
# +++ db2.table2
# @@ -1,4 +1,4 @@
#  ENGINE=InnoDB
# -AUTO_INCREMENT=137
# +AUTO_INCREMENT=2896
#  DEFAULT
#  CHARSET=utf8
Success. All objects are the same.