my_print_defaults


my_print_defaults

my_print_defaults options 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.



MySQL in a Nutshell
MYSQL in a Nutshell (In a Nutshell (OReilly))
ISBN: 0596514336
EAN: 2147483647
Year: 2006
Pages: 134
Authors: Russell Dyer

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net