Compare and diff mysql config files

mysql-diff

#!/bin/bash

extract-keys() {
  <$1 sed 's/#.*//;s/[[:space:]]\+//;/^$/d;/^!/d' |
  gawk -F= '!/^\[/ { print pref "." $1 "\t" $2 } match($0, /\[([^\]]*)\]/, m) { pref = m[1] }' |
  sort
}

(printf "Key %s %s\n--- --- ---\n" $1 $2
join -a1 -a2 -o 0,1.2,2.2 -e. <(extract-keys $1) <(extract-keys $2) | awk '$2 != $3') | column -t