Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Ofer Inbar (cosaaaaa.org)
Date: Wed Jul 25 2007 - 20:40:27 CDT
"Ian P. Christian" <pookeypookey.co.uk> wrote:
> How do I create a mysql data dump from a slave to seed another slave?
> Using --master-data with mysqldump from my existing slave sets the
> master to the slave I was dumping, not the real master.
I started a discussion of the same thing a week or two ago on this
list, if you search the archives (or just google, I bet) you'll see
The quick answer is you can't do it if the slave is in use and needs
to keep replicating. You need to stop replicating, copy down the
slave's master info (you can see it in show slave status), run the
dump while replication is stopped, then start it again.
(Read the earlier thread if you want more detail)
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql