数据库表结构对比

MySQL Utilities的应用

授权

grant select on shanliao1.* to ‘test’@’192.168.0.76’ identified by ‘test910418’;
grant select on shanliao2.* to ‘test’@’192.168.0.76’ identified by ‘test910418’;

grant select  on  mysql.proc  to ‘test’@’192.168.0.76’ identified by ‘test910418’;
grant select  on  mysql.event  to ‘test’@’192.168.0.76’ identified by ‘test910418’;

flush privileges;

比对命令这里–skip-data-check 取消了数据比较，指对比表结构。

mysqldbcompare –server1=test:test910418@192.166.126.162:13306 –server2=test:test910418@192.21.28.139   -a shanliao1:shanliao1 –skip-data-check

mysqldbcompare 安装的话很简单，centos6的话，安装epel源，然后直接yum -y install mysql-utilities即可

其实还有个更详细的比对工具：mysqldiff不过这注重比对表，所以不符合需求。