Percona Tools: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
Dcunningham (talk | contribs) Created page with "=== pt-table-sync === Synchronize MySQL table data efficiently. Documentation: :: https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-sync.html Example command:..." |
Dcunningham (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
=== pt-table-sync === |
=== pt-table-sync === |
||
Synchronize MySQL table data efficiently. |
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: |
Documentation: |
||
:: https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-sync.html |
:: https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-sync.html |
||
Example command: |
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 |
pt-table-sync --password <mysql root password> --execute --sync-to-master h=<other database server>,D=enswitch,t=location --print |
||
Latest revision as of 03:48, 9 April 2018
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