When you use --master-data=1, it executes the CHANGE MASTER command first
before adding data.
Do the following to verify this:
Run 'mysqldump --single-transaction --master-data=1 -h... -u... -p...
DataDump1.sql
Run 'mysqldump --single-transaction --master-data=2 -h... -u... -p...
Thanks for the reply Rolando.
In both the examples I provided (pipe and text file) the CHANGE MASTER
command appears at the top of the data import and is uncommented and
therefore executes before the data is imported. I don't think this is a
problem because the slave only starts replicating from
.
From: Mark Maunder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 12:17 PM
To: Rolando Edwards
Cc: mysql@lists.mysql.com
Subject: Re: Possible bug in mysqldump?
Thanks for the reply Rolando.
In both the examples I provided (pipe and text file) the CHANGE MASTER
*To:* Rolando Edwards
*Cc:* mysql@lists.mysql.com
*Subject:* Re: Possible bug in mysqldump?
Thanks for the reply Rolando.
In both the examples I provided (pipe and text file) the CHANGE MASTER
command appears at the top of the data import and is uncommented and
therefore executes before the data
