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

Reply via email to