Find us on Google+ Google+

November 18, 2018

MySQL mysqldbcompare utility



mysqldbcompare utility commands in MySQL

mysqldbcompare --run-all-tests --server1=host1 --server2=host2 proddb:proddb --changes-for=server1

mysqldbcompare --run-all-tests --server1=host1 --server2=host2 proddb:proddb --changes-for=server1 --disable-binary-logging

mysqldbcompare --run-all-tests --server1=host1 --server2=host2 proddb:proddb --changes-for=server1 --disable-binary-logging -a

mysqldbcompare --run-all-tests --server1=localhost --server2=remotehost $DATABASE:$DATABASE --changes-for=server2 --disable-binary-logging -a --difftype=sql

mysqldbcompare --run-all-tests --server1=master_host --server2=slave_host testdb:testdb --changes-for=server1 --disable-binary-logging --skip-table-options --difftype=sql

mysqldbcompare --run-all-tests --server1=`hostname` --login-path=rhost --server2=dba_login_path --changes-for=server2 --disable-binary-logging --difftype=sql  > mysql_db_compare_log.log

mysqldbcompare --run-all-tests --skip-diff --server1=localhost --server2=rhost --changes-for=server2 --disable-binary-logging --difftype=sql devdb

mysqldbcompare --server1=${USER}:${PASS_WORD}@${HOST1}:3310 --server2=${USER}:${PASS_WORD}@${HOST2}:3310 ${DB}:${DB} --run-all-tests --changes-for=server2 --difftype=sql

mysqldbcompare -v --run-all-tests --server1=host1 --server2=host2 proddb:proddb --skip-object-compare -a

mysqldbcompare -v --run-all-tests --server1=localhost --server2=remotehost proddb:proddb --skip-object-compare --changes-for=server2 -a -- skip-data-check

mysqldbcompare -v --run-all-tests --server1=host1 --server2=host2 proddb:proddb --skip-data-check --changes-for=server2 -a -- disable-binary-logging

mysqldbcompare -v --run-all-tests --server1=master_host --server2=slave_host proddb:proddb --changes-for=server1 --disable-binary-logging -a


Related Articles: 
mysqlshow utility commands    mysqlbinlog utility commands