Check in the slave's master.info file In the first line you'll see a filename for the master's binary log an in the second line you'll see the position.
Look at the file on the master server and compare the byte -size to the position. I wrote a little perl script/netsaint plugin that takes care of this. Let me know if you need it. Patrick Ouellet wrote: >Ok I have a MySQL server. >And I have another MySQL server which is the replication >of the other DB server. > >What I want to know is: > >Is there a way to know if the replication server has finished >replicating the master server. > >I think my DB has been corupted. ( A process on another >machine wrote to the replication server when the master >server was down. ) Well the replicated DB is larger than >the Master's DB > >So I want to wait until the replication server has finished >its replication, then use the slave's DB to overwrite >the master DB and resume normal operation. > >Is that a good idea? > >Thanx everyone. > >-A newbie MySQL admin. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
