From: MAS! Date: May 5 2009 3:53pm Subject: Re: backup from a slave List-Archive: http://lists.mysql.com/mysql/217406 Message-Id: MIME-Version: 1.0 (Apple Message framework v753.1) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Content-Transfer-Encoding: 7bit > 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. > ok, thanks, I was thinking it'd be a better solution. btw, I have to get the Master_Log_File and Read_Master_Log_Pos or Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave correctly !? (my slave is not always updated in 'realtime') thank you in advance MAS!