How to pretty-print my.cnf with a one-liner

June 15, 2009

Author

Baron Schwartz

Insight for DBAs

Share this Post:

When I’m looking at a server, I often want to see the /etc/my.cnf file nicely formatted, and with comments stripped. This Perl one-liner will pretty-print the file:

<br>perl -ne 'm/^([^#][^s=]+)s*(=.*|)/ &amp;&amp; printf("%-35s%sn", $1, $2)' /etc/my.cnf<br>[client]                           <br>port                               = 3306<br>socket                             = /var/run/mysqld/mysqld.sock<br>[mysqld_safe]                      <br>socket                             = /var/run/mysqld/mysqld.sock<br>nice                               = 0<br>[mysqld]                           <br>user                               = mysql<br>pid-file                           = /var/run/mysqld/mysqld.pid<br>socket                             = /var/run/mysqld/mysqld.sock<br>port                               = 3306<br>....<br>

1

perl -ne 'm/^([^#][^s=]+)s*(=.*|)/ && printf("%-35s%sn", $1, $2)' /etc/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 ....