Here is my example BULK COPY and DELETE -
pt-archiver --source h=10.0.10.140,D=db,t=table,u=perconatool,p=pswd--dest h=10.0.2.116,D=DB,t=table,u=perconatool,p=pswd,L=yes --where "DTime<='2014-08-21' and DTime>'2014-07-30'" --limit 400 --txn-size 400 --statistics --progress 1000 --max-lag 10 --retries 10 --bulk-insert --bulk-delete --password pswd --check-slave-lag h=10.0.10.137 --check-slave-lag h=10.0.10.138 --check-slave-lag h=10.0.10.139
Here is my example BULK COPY and DELETE -
pt-archiver --source h=10.0. 10.140, D=db,t= table,u= perconatool, p=pswd- -dest h=10.0. 2.116,D= DB,t=table, u=perconatool, p=pswd, L=yes --where "DTime< ='2014- 08-21' and DTime>'2014-07-30'" --limit 400 --txn-size 400 --statistics --progress 1000 --max-lag 10 --retries 10 --bulk-insert --bulk-delete --password pswd --check-slave-lag h=10.0.10.137 --check-slave-lag h=10.0.10.138 --check-slave-lag h=10.0.10.139