Not the answer you need?
Register and ask your own question!

pt-table-sync

epinettiepinetti EntrantCurrent User Role Beginner
I m new with this tool.. and trying to follow the tutorial/Forum comments to sync 2 tables between 2 servers

pt-table-sync --execute h=host1,D=db,t=tbl h=host2

Test 1:
pt-table-sync --execute -u=root -p=xxxxx h=server_source.com, D=database_source, t=table_souce_user h=server_target

Response:
You specified a database but not a table in D=database_source,. Are you trying to sync only tables in the 'atabase_source' database? If so, use '--databases atabase_source' instead.


Test 2:
pt-table-sync --execute -u=root -p=xxxxx h=server_source.com, D=database_source, t=table_souce_user -u=root -p=password h=server_target

Response: same as above


I am not sure also if the parameters are between quotas or not (p, u, t etc)


Can someone help me out?,.. what I am missing?

Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.