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

PREVIOUS POST
NEXT 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:

PREVIOUS POST
NEXT POST

Comments

  1. says

    Nice, i like awk so i give you mine with sections separated by a line:
    awk ‘! /^#/ && ! /^$/ {if($1 ~ /^\[/ ){gsub(“\[“,”\n[“,$1) };printf(“%-35s%s %s\n”,$1, $2, $3)}’ /etc/my.cnf

    cheers.

  2. Jacob Sohn says

    shorter version – :)
    awk ‘! /(^#|^$)/ {printf “%-34s %s %s\n”, $1, $2, $3}’ /etc/my.cnf

    if you don’t care about pretty formats – :)
    grep -Ev ‘(^#|^$)’ /etc/my.cnf

    -jacob

  3. says

    The awk versions work well as long as there’s whitespace, but they won’t pretty-print

    port=3306

    I like awk too, but I’m so clumsy with it that I’m not sure what to do to fix that!

    (PS: the Perl version doesn’t pretty-print things without whitespace perfectly either, but it’s pretty enough for me)

  4. Jacob Sohn says

    using field separator option and if condition, with or without white space shows pretty format – :)

    awk -F= ‘! /(^#|^$)/ { if ($2 != “”) printf “%-34s = %s\n”, $1,$2; else printf “%s\n”, $1 }’ /etc/my.cnf

    I admit, this is longer than i want it to be…

    -jacob

  5. Seth says

    Any hints on how to get this to work as a bash alias?

    I would like to add something like this to my .bashrc:

    alias printmycnf=

    but no amount of quote hacking is getting it to work.

    Or has someone refactored it has a perl script? I think I could do that, but my first attempt was taking longer than 5 minutes so I thought I would ask.

    Thanks

  6. Jacob Sohn says

    @Seth
    knowning where to escape, you should be able to do as this;

    alias printmycnf=’awk -F= “! /(^#|^$)/ { if (\$2 != \”\”) printf \”%-34s = %s\n\”, \$1,\$2; else printf \”%s\n\”, \$1 }”‘

    you can replace with perl one-liner where awk is.

    -jacob

  7. Seth says

    @Jacob – Not sure what’s going on here… but the quoting is messed up. Appears to be the MS-SmartQuotes / unicode issue. Some of the double-quotes above are leaning one direction and some are leaning the other way. When I paste it as is into my terminal I get:

    alias printmycnf=.awk -F= .! /(^#|^$)/ { if (\$2 != \.\.) printf \.%-34s = %s\n\., \$1,\$2; else printf \.%s\n\., \$1 }..

    Did you copy and paste from somewhere weird, like a word document or something? I tried to modify it back to what it should be:

    alias printmycnf=’awk -F= “! /(^#|^$)/ { if (\$2 != \”\”) printf \”%-34s = %s\n\”, \$1,\$2; else printf \”%s\n\”, \$1 }”‘

    But when I ran it (RHEL 4.8) it just hung. I’ve tried inserting the perl string as an alias and doing various things to escape the quotes w/l much luck.

    I guess I could just put the command into a shell script for now.

  8. Seth says

    Appears that WordPress is messing up the quotes for us, as my post is exhibiting the same quoting issue.

  9. Jacob Sohn says

    @Seth

    Yeah, the “,’,` characters gets altered from ISO-8859-1 to UTF-8 probably. Copy and paste the code and just replace those characters with proper ones. Then all should work fine.

    -jacob

  10. Jacob Sohn says

    @Seth

    have you tried “printmycnf /etc/my.cnf” after alias command?

    On my system;
    $ alias printmycnf=’awk -F= “! /(^#|^$)/ { if (\$2 != \”\”) printf \”%-34s = %s\n\”, \$1,\$2; else printf \”%s\n\”, \$1 }”‘
    $ printmycnf /etc/my.cnf

    works like a charm.

    ps: don’t forget to replace single quote and double quote. better yet, just type it in manually.

Leave a Reply

Your email address will not be published. Required fields are marked *