What about just issuing a PURGE MASTER LOGS TO master-bin.007 on the master and then starting the slave without a master.info file? I think that will recreate it for you -- but you should research this before trying...
--jeff ----- Original Message ----- From: "James Fidell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 15, 2003 4:52 PM Subject: recreating master.info for a slave > 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 > --------------------------------------------------------------------- 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
