MySQL Forums
Forum List  »  Utilities

Re: mysqldbreport not showing differences
Posted by: al omary
Date: June 12, 2017 07:27AM

Please let me know if you need more details.
You can see the difference in count below.
Thanks.

# local host
root@oldb04> show variables where Variable_name like '%hostname%';

+---------------+----------------------------+
| Variable_name | Value |
+---------------+----------------------------+
| hostname | poldb04 |
+---------------+----------------------------+
1 row in set (0.00 sec)

root@poldb04> insert into history.policy_update values(999999, 'test', 'test', now());
Query OK, 1 row affected (0.00 sec)

root@poldb04> select count(*) from history.policy_update;
+----------+
| count(*) |
+----------+
| 255092 |
+----------+
1 row in set (0.12 sec)



# remotee host
root@localhost> show variables where Variable_name like '%hostname%';
+---------------+----------------------------+
| Variable_name | Value |
+---------------+----------------------------+
| hostname | poldb03 |
+---------------+----------------------------+
1 row in set (0.00 sec)

root@localhost> select count(*) from history.policy_update;
+----------+
| count(*) |
+----------+
| 255870 |
+----------+
1 row in set (0.07 sec)

# running dbcompare
# server1 on poldb04: ... connected.
# server2 on poldb03: ... connected.
# Checking databases history on server1 and history on server2
#
# Defn Row Data
# Type Object Name Diff Count Check
# -------------------------------------------------------------------------
# TABLE policy_update pass pass -
# - Compare table checksum pass

# Databases are consistent.
#
# ...done

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysqldbreport not showing differences
97
June 12, 2017 07:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.