Mitsuru,
Friday, January 25, 2002, 8:12:02 AM, you wrote:
MH> What would be the most effective way to compare 2 databases to see if
MH> they are identical? This is for the replication. We would like to check
MH> if a slave DB is identical to the primary DB.
For example, you can compare mysqldu
If this is on a Unix flavor, you can use 'cmp' to compare the data and
index files (off-line, of course). Once you know they are identical,
you can simply plot the difference between the slave's update log position
and the master's update log position. As long as it's always 0, the
two are in s
On Fri, Jan 25, 2002 at 03:12:02PM +0900, Mitsuru Hirai wrote:
> Hello.
> What would be the most effective way to compare 2 databases to see
> if they are identical? This is for the replication. We would like
> to check if a slave DB is identical to the primary DB.
What, you don't trust it?! :-
Hello.
What would be the most effective way to compare 2 databases to see if
they are identical? This is for the replication. We would like to check
if a slave DB is identical to the primary DB.
Thank you very much.
Mitsur Hirai
