Percona Tools
Revision as of 03:48, 9 April 2018 by Dcunningham (talk | contribs)
pt-table-sync
Synchronize MySQL table data efficiently. The table must have a primary key. If changing the location table and it doesn't have one, you must add one first, and then remove it afterwards.
Documentation:
Example command to sync the location table:
pt-table-sync --password <mysql root password> --execute --sync-to-master h=<other database server>,D=enswitch,t=location --print
