mysql 数据库之间数据区别对比

wget https://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-2.1.7.tar.gz

tar xf mysql-connector-python-2.1.7.tar.gz
cd mysql-connector-python-2.1.7

python setup.py build
python setup.py install

wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities-1.6.5.tar.gz

tar xf mysql-utilities-1.6.5.tar.gz
cd mysql-utilities-1.6.5
python setup.py build
python setup.py install

mysql_config_editor set --login-path=instance-3306 --host=localhost --user=root --port=3306 --password

mysql_config_editor print --login-path=instance-3306

查看加密.jpg

mysqldbcompare --server1=instance-3306 testjeecg:test_test_jeecg --run-all-tests

显示.jpg

mysqldbcompare --server1=instance-3306 testjeecg:test_test_jeecg --run-all-tests  --difftype=sql  -vvv

--difftype=sql 选项生产差异的SQL语句,同时，使用 --show-reverse选项可以显示出双方的SQL语句

对比过程图.png