Announcement

Announcement Module
Collapse
No announcement yet.

pt-archiver and using a config file

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-archiver and using a config file

    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:

    Code:
    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"

    Comment

    Working...
    X