List:Replication« Previous MessageNext Message »
From:nhadie ramos Date:April 4 2012 4:09am
Subject:discrepancy on a single table
View as plain text  
Hi

Is it possible if i grab a dump of a certain table from the master
restore it on the slave and start replication again?
I have a table that is is not synched on the server, i have tried
using pt-table-checksum to that table but i get the error "because 1
cannot be nibbled safely."

so i'm thinking of just stopping the slave, grab a dump of the table
and restore to slave. will there be any data corruption?

thanks in advance.

Regards,
Ron
Thread
discrepancy on a single tablenhadie ramos4 Apr
  • Re: discrepancy on a single tableshawn green4 Apr
    • Re: discrepancy on a single tableumapathi b4 Apr
      • Re: discrepancy on a single tablenhadie ramos4 Apr
      • Re: discrepancy on a single tableJohan De Meersman4 Apr
        • Re: discrepancy on a single tablePrabhat Kumar4 Apr
    • Re: discrepancy on a single tablenhadie ramos4 Apr
      • Re: discrepancy on a single tableMarcus Bointon4 Apr
        • Re: discrepancy on a single tablenhadie ramos4 Apr
          • Re: discrepancy on a single tableMarcus Bointon4 Apr
          • Re: discrepancy on a single tablenhadie ramos4 Apr