I have two databases on localhost: db1 and db2. I want to pt-table-sync all tables on db2 to be exactly like their equivalents on db1. I tried the following command line:
$ pt-table-sync --dry-run h=localhost,u=user,p=pass,d=db1 h=localhost,u=user,p=pass,d=db2
This failed with the following error:
you specified a database but not a table in h=localhost,u=user,p=pass,d=db1. are you trying to sync only tables in the 'db1' database? if so, use '--databases db1' instead.
I also tried dropping the D part of both DSNs, and instead specify
This shows zero differences, even though in reality differences do exist. I’m guessing what it does is compare each database to itself.
Is there a way to do this with pt-table-sync?