May 25, 2012

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

June 15, 2009 By 17 Comments

… to see the /etc/my.cnf file nicely formatted, and with comments stripped. This Perl one-liner will pretty-print the file: perl -ne ‘m/^([^#][^\s=]+)\s*(=.*|)/ && printf(“%-35s%s\n”, $1, $2)’ /etc/my.cnf [client] port = 3306…

Filed Under: Insight for DBAs Tagged With: