Hi,
Try to issue below command before dumping data on master server:
flush table with read lock
Check the manual http://dev.mysql.com/doc/refman/5.1/en/flush.html
Regards,
Brandon
--------------------------------------------------
From: "Muthukumar Selvarasu" <muthukumar_se@stripped>
Sent: Tuesday, July 28, 2009 1:13 AM
To: "'Rajakumar Velu'" <vrkumar79@stripped>; <replication@stripped>
Subject: RE: mysqldump has extra records
> Hi
>
> Try this steps
>
> 1. stop slave
> 2. dump master records.
> 3. backup slave raw/dump data
> 4. remove the slave data and restore it
>
>
> Regards
> Muthukumar Selvarasu,
> Project Manager Web Development,
> Webmasters Fijilive Groups.
>
>
> -----Original Message-----
> From: Rajakumar Velu [mailto:vrkumar79@stripped]
> Sent: Tuesday, July 28, 2009 3:17 AM
> To: replication@stripped
> Subject: mysqldump has extra records
>
> Hi All,
>
> I have master slave replication,
>
> my slave got error, so I took DB dump from Master using
>
> /usr/bin/mysqldump --master-data --single-transaction --quick --opt
> --databases 1234 -p > 1234.dmp
>
> when i restore the dump to on the slave it have some additional records on
> some of the tables,
>
> before start the slave I have reset the master log name and positions
>
> I didn't faced any error while dump, restore and restart the slave,
>
> Could some help me
>
> Regards,
> Rajakumar
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
>
>
