Re: seeding a slave from a slave

2007-07-25 Thread Ananda Kumar
Hi Ofer, Is it necessary to stop the slave before doing the mysql dump. If we use --single-transaction option in mysqldump should provide consistent backup..right. or stop slave note the slave status info. start slave start mysqldump. regards anandkl On 7/26/07, Ofer Inbar <[EMAIL PROTECTED]>

Re: seeding a slave from a slave

2007-07-25 Thread Ofer Inbar
"Ian P. Christian" <[EMAIL PROTECTED]> 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 t

seeding a slave from a slave

2007-07-25 Thread Ian P. Christian
Hi All, 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. Many Thanks, Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/my