List:Replication« Previous MessageNext Message »
From:MEI QiuSheng Date:July 29 2009 12:21pm
Subject:Re: mysqldump has extra records
View as plain text  
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
> 
>
Thread
mysqldump has extra recordsRajakumar Velu27 Jul
  • RE: mysqldump has extra recordsMuthukumar Selvarasu27 Jul
Re: mysqldump has extra recordsMEI QiuSheng29 Jul