For reasons too boring to warrant going into here, I have a slave server which is synchronised with the master up to the very start of binary log 007, but I have no valid master.info file.
I don't want to stop the master if at all possible. All I want to do is to re-create a suitable master.info file on the slave to begin at the start of the 007 binary log. So, I have created one like: master-bin.007 ??? master.host.name <username> <password> 3306 60 How do I work out what index value should go in the position ???, given that I want the slave to begin at the start of the binary log? James sql query --------------------------------------------------------------------- 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