Comparing two MySQL Databases

WeNdeL · 09-24-2003, 09:53 AM

I have two MySQL servers set up in a Master/Slave type relationship. I have not configured them as master/slaves but am using binary logging to keep the slave up-to-date. I run a cron job that handles the transferring of binary logs every night.

I am not certain if my cron job has been 100% successful in updating the slave. Is there a way to compare the databases on both servers to see if they are identical?

Thanks in advance!

Kintar · 09-30-2003, 03:47 PM

I'm not certain it's exactly what you're looking for, but the diff command will compare two files and show you where they differ, if at all.

-- Kintar