MAS! wrote:
I'd like to use that backup to setup a new slave (from the same (and unique) master); the problem is I don't know how set-up this new slave, since I don't know the right master binary-log num and position; in the backup I have the "slave's" binary-log/pos and not the master ones :(
One way to do this would be to issue a 'stop slave;' on the slave you are taking a backup from just before the backup starts. Then issue a 'show slave status\G' to get the master log file and position. You can use this to setup the new slave properly.
Remember to issue a 'start slave;' after taking the backup, but also after you obtain the master log file and position.
HTH, -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
