|
|||||||||||
|
Re: bin-log position.
From: Alex Arul Lurthu <alex.lurthu(at)gmail.com>
Date: Mon Jul 09 2007 - 00:48:10 EDT
If the dump was taken from the slave then the binlog positions that were dumped out are that of the slave. Now you might do 2 things :
To do this use the binlog positions that you obtained using the command show slave status on your slave. The master log file will be " mysql-bin.000029" . But your show slave output status doesnt show the exe_master_log position. You need to use that position for setting up a new slave of your master. 2. Setup a slave of your slave To do this use the binglog positions in your mysqldump output. P.S: Make sure you setup the hostnames in the change master command appropriately. -- Thanks Alex http://blog.360.yahoo.com/alex.lurthuReceived on Mon Jul 9 00:49:00 2007 This archive was generated by hypermail 2.1.8 : Tue Jul 10 2007 - 21:34:33 EDT |
||||||||||
|
|||||||||||