From: nhadie ramos Date: April 4 2012 8:16pm Subject: Re: discrepancy on a single table List-Archive: http://lists.mysql.com/replication/2338 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi All, I fixed the discrepancy by just running pt-sync with --sync-to-master option and no checksum. thanks for all your advise! Regards, Ron On Wed, Apr 4, 2012 at 4:07 PM, nhadie ramos wrote: > Hi Marcus, > > i have tried xtrabackup before but not for a single table. tried it > for my whole DB, the prob i have is that it locks the tables which i > cant afford doing on the live server > coz if i can lock the database i would simply grab the whole mysql > directory and transfer it to the slave the restore replication. i will > look into the single table option. thanks! > > Regards, > Ron > > On Wed, Apr 4, 2012 at 3:20 PM, Marcus Bointon > wrote: >> On 4 Apr 2012, at 07:43, nhadie ramos wrote: >> >>> thanks for the reply, i will try these one if i am getting these >>> correctly. i will stop slave, then run mysqldump with master-data >>> option so i can get the file and log position. >> >> Not sure if you've tried it, but xtrabackup is way better than using mys= qldump for setting up a slave. It does imply that you do a complete data re= store, but it is transaction-safe, much faster and more reliable, and it ke= eps track of binlog position nicely. >> >> It also has an ability to deal with individual databases and single tabl= es but I've not looked into that. >> >> Marcus >> -- >> Marcus Bointon >> Synchromedia Limited: Creators of http://www.smartmessages.net/ >> UK info@hand CRM solutions >> marcus@stripped | http://www.synchromedia.co.uk/ >> >> >> >> >> -- >> MySQL Replication Mailing List >> For list archives: http://lists.mysql.com/replication >> To unsubscribe: =A0 =A0http://lists.mysql.com/replication >>