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

pt-summary cannot find config file

dvandvan EntrantCurrent User Role Participant
The following works fine,

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

but I get:

# Configuration File #########################################
Config File | Cannot autodetect or find, giving up

Any way to get that working?

Thx
D

Comments

  • mirfanmirfan Database Administrator Inactive User Role Mentor
    What you get's without options ? like below.

    $ pt-mysql-summary -- --user=root --password=<mysql-root-password>
  • brdbrd Current User Role Poster
    Do not confuse Percona toolkit configuration file with MySQL .cnf.
    --config is for Percona toolkit
    --defaults-file and DSN F specifier is for MySQL .cnf
    e.g. to connect to a DSN with the account in .cnf use
    h=127.0.0.1,P=3366,F=./pt.cnf
    [client]
    user = ...
    password = ...


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.