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

pt-archiver and using a config file

Joe GIbbsJoe GIbbs EntrantCurrent User Role Novice
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

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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"
    
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.