Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Ofer Inbar wrote:
> > host a is the master
> > host b is a replication slave
> > host c is to become a second replication slave
> > there's no full dump from host a
> >One possibility I can think of:
> > - stop slave on host b
> > - run the dump on host b
> > - note its position in host a's binlogs using "show slave status"
> > - restore the dump on host c
> > - start c slaving using the binlog name and position from "show slave
> > status"
> >
> >Will that work?
>
> Yes.
For the benefit of future readers of the archive: yes, it worked easily.
> Just be aware of which columns of SHOW SLAVE STATUS
> mean what -- there are three sets of binlog coordinates in that output.
> (There's a note on the online manual that should make it clear).
The columns I used were:
Master_Log_File: binlog.000008
Read_Master_Log_Pos: 150484312
-- Cos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
