# How to sync tables with triggers?

**URL:** <https://forums.percona.com/t/how-to-sync-tables-with-triggers/2582>\
**Category:** Percona Toolkit\
**Created:** [September 11, 2012, 7:54am UTC](https://forums.percona.com/t/how-to-sync-tables-with-triggers/2582 "2012-09-11T07:54:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dchicks](https://avatars.discourse-cdn.com/v4/letter/d/ed8c4c/32.png) [@dchicks](https://forums.percona.com/u/dchicks)\
**Post date:** [September 11, 2012, 7:54am UTC](https://forums.percona.com/t/how-to-sync-tables-with-triggers/2582/1 "2012-09-11T07:54:06Z")

</div>

I’ve got two slaves that have somehow become out of sync with the master. Each is giving me HA\_ERR\_KEY\_NOT\_FOUND errors when trying to execute updates in replication. I tried to sync them to the master, but the tables contain triggers. So, pt-table-sync doesn’t want to execute anything.

Does anyone know of a reliable procedure for bringing such tables back into sync?

Right now, I do not have the luxury of getting rid of the triggers.

Thanks,  
Dave