MySQL Forums
Forum List  »  Data Recovery

Re: finding and restoring new data
Posted by: Umarzuki Mochlis Moktar
Date: February 22, 2017 08:14AM

mysqldbcompare seems only can check if there's object definitions dissimilarities and failed

mysqluc> mysqldbcompare --server1=root:password@192.168.132.10 --server2=root:password@192.168.132.10 --difftype=sql livedb:restore210217
# WARNING: Using a password on the command line interface can be insecure.
# server1 on 192.168.132.10: ... connected.
# server2 on 192.168.132.10: ... connected.
# Checking databases livedb on server1 and restore210217 on server2
#
# Defn Row Data
# Type Object Name Diff Count Check
# -------------------------------------------------------------------------
# TABLE moving pass pass -
# - Compare table checksum FAIL
# - Find row differences pass
# TABLE regular pass pass -
# - Compare table checksum FAIL
# - Find row differences pass
# TABLE budget FAIL ERROR: The object definitions do not match.

Execution of utility: 'mysqldbcompare --server1=root:password@192.168.132.10 --server2=root:password@192.168.132.10 --difftype=sql livedb:restore210217' ended with return code '1' but no error message was streamed to the standard error, please review the output from its execution.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: finding and restoring new data
767
February 22, 2017 08:14AM
738
February 22, 2017 03:35PM


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.