Baron Schwartz <baron@xaprb.com> 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