GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

diff

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

  • diff

    I cannot get the following to work:

    pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=metasrcha

    (the databases are correct, and available to user as specified in mypercdvd.cnf)

    I cannot figure out how to get a 'verbose' thingy going on this command, but stdout is:

    me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=metasrcha
    DBI connect('metasearch;mysql_read_default_file=/mampstack/mypercdvd.cnf;mysql_read_default_group=client','', ...) failed: Access denied for user 'me'@'localhost' (using password: NO) at /usr/local/bin/pt-config-diff line 2055.

    I correct the username, and get no output:
    me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch,u=dvd,p=XXX D=metasrcha,u=dvd,p=XXX


    I compare entirely different databases, and get no output:
    me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch,u=dvd,p=XXX D=topic3d,u=dvd,p=XXX

    I set the username and password in a cnf file, in sections [mysql] and [client] (duplicated values) and get no output:
    me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=topic3d

    me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=metasrcha






    The following command works very nearly perfectly:

    pt-mysql-summary --config=/usr/local/mysql/my.cnf --defaults-file=/mampstack/mypercdvd.cnf --all-databases


    Please tell me how to obtain a verbose log on pt-config-diff, and how to perfect my pt-config-diff commands above.
    Thx

    (btw, I think this is a great toolkit!)

    D

  • #2
    What is it you are actually attempting to do? The command you are running is logically trying to diff the config of the same MySQL instance with itself (you're just giving it two database names, not two hosts). pt-config-diff is used to compare the configs of two different hosts, or option files.

    Take a look at the three examples in the manual; they are pretty straight forward as far as comparing two hosts, two option files, or a host and an option file:

    http://www.percona.com/doc/percona-t...nfig-diff.html

    Comment

    Working...
    X