Re: bin-log position.

Hi Alex,
Thanks a lot,
I missed on taking the "exe_master_log position" value. If i start from Read_Master_Log_Pos: 106683511, will it cause any harm.

regards
anandkl

On 7/9/07, Alex Arul Lurthu <alex.lurthu@gmail.com> wrote:
>
> Anand,
>
> 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 :
>
> 1. Setup a slave of your master
>
> 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.lurthu
>
>
>
Received on Mon Jul 9 01:02:09 2007