Name
my_print_defaults
Synopsis
my_print_defaultsoptions
filename
Use
this to parse a configuration file so as to convert 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 the
--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 the header [mysqld]
and the blank lines are
not included in the output. Also, each key/value pair is printed on
separate lines. To parse more than one section, you can list
additional section names at the end of the command line, separated by
spaces.
Get MySQL in a Nutshell 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.