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