On Mon, 14 Feb 2005, Jeremy Cole wrote:
> AFAIK, the log file name is not known by the slave unless it either
> receives a rotate log event (go to next log) or you have started it
> against a particular log file. If you start replication "from the
> beginning" (not specifying a log file) against a master, the first
> filename is not passed down.
> In order to force a filename to be displayed you could either: FLUSH
> LOGS on the master, or specify the log file name in the CHANGE MASTER on
> the slave.
If that's the case it would have to mean that the SQL thread knew about it
while the IO thread did not, correct? Here's a snip of the SHOW SLAVE
STATUS from yesterday:
The way the seeding was done was that the slave got a copy of the
replicated DB + master.info from an existing slave.