mysqldbcompare - ERROR: The list of objects differs among database

I'm running:

# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.5 (Santiago)
# rpm -q mysql-server
mysql-server-5.1.73-3.el6_5.x86_64
#

and

mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.1.73-log |
+------------+
1 row in set (0.00 sec)

mysql>

I'm trying to run mysqldbcompare against two mysql server and running into following error:

$ mysqldbcompare -vvv --server1=XXX:XXX@XXX:3306 --server2=XXX:XXX@XXX:3306 pressflow6:pressflow6
# server1 on XXX: ... connected.
# server2 on XXX: ... connected.
# Checking databases pressflow6 on server1 and pressflow6 on server2
#
ERROR: The list of objects differs among database pressflow6 and pressflow6.
$

I just ran mysqldump to export it on server1 and import it to server2 and I'm able to run it against other database without any issues.

Any ideas why I'm unable to run mysqldbcompare successfully?

Check that you have enough permission on both databases to see and select your tables.

You could do a poor's man mysqldbcompare to check that:

mysqldump -d -h server1 -u user1 -ppassword1 pressflow6 > objects1.sql
mysqldump -d -h server2 -u user2 -ppassword2 pressflow6 > objects2.sql
diff objects1.sql objects2.sql

StackExchange Database Administrators Q#74389, answer score: 4