Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: bin-log position.

From: Alex Arul Lurthu <alex.lurthu(at)gmail.com>
Date: Mon Jul 09 2007 - 00:48:10 EDT


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 00:49:00 2007

This archive was generated by hypermail 2.1.8 : Tue Jul 10 2007 - 21:34:33 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library