Re: Doing backups and restores from slaves

[David L. Sifry]

An update to the problem, and a workaround (bug report?):

Jeremy Zawodny wrote:

While the tables are locked, be sure to also copy the slave's
master.info file, relay log(s), and relay index file.  Transfer all of
that to the other slave and you should be good to go.
Does that make sense?

 

Actually, that's exactly what I did (the tarball of the /var/lib/mysql 
directory includes the master.info, relay logs, and relay index file) 
but with no joy.

What finally got it to work was to make the following changes:

The relay bin file copied over is called "slave1-relay-bin.xxx" and the 
relay bin index file is called "slave1-relay-bin.index".

I had to change things around because the new slave I was copying to is 
called "slave2".

1. mv slave1-relay-bin.xxx slave2-relay-bin.xxx
2. mv slave1-relay-bin.index slave2-relay-bin.index
Then I had to edit the first line of relay-log.info to point to the new 
files, changing "slave1-relay-bin.xxx" to "slave2-relay-bin.xxx":

Then I started mysql, and did a SLAVE START and everything worked.

Is this a bug?

Dave

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]