Name
my_print_defaults
Synopsis
my_print_defaultsoptions
filename
This utility parses a configuration file, converting key/value
pairs into command-line equivalent options. For instance, a line from
the my.cnf file that reads
basedir=/data/mysql
will be converted to
--basedir=/data/mysql
. To export the MySQL daemon
(i.e., mysqld) section of
my.cnf file, enter the following from the command
line (the output follows):
my_print_defaults --config-file=/etc/my.cnf mysqld --basedir=/data/mysql --datadir=/data/mysql --socket=/tmp/mysql.sock --tmpdir=/tmp --log-bin=/data/mysql/logs/log-bin
Notice that only the mysqld
section is parsed
and that the header [mysqld]
and the blank lines are
not included in the output. Also, each key/value pair is printed on a
separate line. To parse more than one section, you can list additional
section names at the end of the command line, separated by
spaces.
Here is a list of options available for this utility in alphabetical order:
--config-file=
filename
, --defaults-file=filename
, -cfilename
This option instructs the utility to read only the given configuration or options file (i.e., my.cnf or my.ini).
--debug[=
options
], -# [options
]This option logs debugging information. The set of options used by default is
'd:t:o,logname'
. See Table 16-1 at the end of the list of options under themysqldump
utility for an explanation of these flags and others that may be used.--defaults-extra-file=
filename
, --extra-file=filename
, -efilename
This option instructs the utility ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.