mysql数据差异化比对-mysqldiff

2020-11-18

字数统计: 172字 | 阅读时长≈ 1分

安装mysqldiff工具

yum remove mysql-connector-python -y

#centos 7
rpm -Uvh http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/mysql-connector-python-2.1.8-1.el7.x86_64.rpm

yum install -y mysql-utilities

mysql数据库比对

1	mysqldiff --server1=root:root123@192.168.0.13:3306 --server2=root:root123@192.168.0.13:3306 --force --di23@192.168.0.13:3306 --force --difftype=sql kr_game_xxx:sntdw_kr_game_xxx

mysql表比对

1	mysqldiff --server1=root:root123@192.168.0.13:3306 --server2=root:root123@192.168.0.13:3306 --force --di23@192.168.0.13:3306 --force --difftype=sql kr_game_xxx.info:sntdw_kr_game_xxx.info

执行结果类似如下：

# WARNING: Using a password on the command line interface can be insecure.
# server1 on 192.168.0.13: ... connected.
# server2 on 192.168.0.13: ... connected.
# Comparing kr_game_70001.role_info to sntdw_kr_game_70001.role_info   [PASS]
# Success. All objects are the same.  ------ 这行信息表示数据库比对结果一致

本文作者： GaryWu
本文链接： https://garywu520.github.io/2020/11/18/mysql数据差异化比对-mysqldiff/
版权声明： 本博客所有文章除特别声明外，均采用 MIT 许可协议。转载请注明出处！

jsonContent: meta: false pages: false posts: title: true date: true path: true text: false raw: false content: false slug: false updated: false comments: false link: false permalink: false excerpt: false categories: false tags: true