4

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?

1 Answer 1

4

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
4
  • I DO have enough permissions on both databases to see and select my tables, as I'm using same permissions to check other database without any issue.
    – alexus
    Commented Aug 20, 2014 at 13:46
  • 1
    @alexus What happens when you run it with the -a option?
    – jynus
    Commented Aug 20, 2014 at 15:06
  • 3
    i usually run it with --run-all-tests, but this time I didn't, so after throwing --run-all-tests back in, it works! Thanks!
    – alexus
    Commented Aug 20, 2014 at 17:08
  • -a option helped my mysqldbcompare progress to show DB content differences, also some annoying test output. I prefer the poor man's method to avoid horrendously long and ugly table-formatted output for comparisons. I also removed the -d, as I wanted to compare db entries, not just the schema, and added --skip-extended-insert to have a more easily readable diff (P4Merge on Mac helps with per-character diffs better than some other programs). Also, mysqldump allowed me to avoid putting the password explicitly on the command line.
    – Pysis
    Commented Aug 13, 2017 at 5:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.