pt-archiver and using a config file

Polyglot Projects Percona Toolkit
1

Hi

We have a copy of pt-archiver running on one environment and I need to set up a 2nd archive script for a new application. Instead of have a long string that I build and tack onto the pt-archiver command I want to use config files. However I am having an issue with the config files and getting them to work with the pt-archiver script.

The current problem is that I can’t get it to recognize the source or dest option settings in the config file.

Am looking for some examples of how the config file works with the archiver script.

Thanks
Joe Gibbs

2

Hi,

Let me show you an example then. This one will make a simple copy of a table to another one.
Create file: /etc/percona-toolkit/pt-archiver.conf with contents in this form:

source=h=localhost,S=/tmp/mysql_sandbox5531.sock,D=test,t=test,b=1
dest=h=localhost,S=/tmp/mysql_sandbox5531.sock,D=test,t=test_copy,b=1
no-delete
limit=5000
commit-each
where="1=1"