CODEWITHSUNDEEP
mysqlxtradbmysqldbcompare
Saikumar A
Saikumar A

Reputation: 223

msqldbcompare failed because of special characters

I'm trying to compare master and slave using mysqldbcompare utility, but observed that it's getting failed and in compare result its not showing difference rows.so I manually compared tables and observed that there is some special character in master is making this difference in slave as '?'. Please let me know how can I avoid this issue.

below is the sample record from master and slave.

Master:

mysql> select description  from mp_prod.devices where id=22672\G;
*************************** 1. row ***************************
description: Amanda iPad - 😀
1 row in set (0.00 sec)

slave :

mysql> select description  from mp_prod.devices where id=22672\G;
*************************** 1. row ***************************
description: Amanda iPad - ?

Upvotes: 0

Views: 50

Answers (0)

Related Questions