aboutsummaryrefslogtreecommitdiff
path: root/sh/shrc.d/mysql.sh
diff options
context:
space:
mode:
authorTom Ryder <tom@sanctum.geek.nz>2016-08-17 17:38:45 +1200
committerTom Ryder <tom@sanctum.geek.nz>2016-08-17 17:38:45 +1200
commit67afb66eb1a2e7a1f7c912bdeec002de7b25d91d (patch)
tree0701c5da159452f229eb50a8b1f99387b31a01fe /sh/shrc.d/mysql.sh
parentOnly pull if rebase possible (diff)
downloaddotfiles-67afb66eb1a2e7a1f7c912bdeec002de7b25d91d.tar.gz
dotfiles-67afb66eb1a2e7a1f7c912bdeec002de7b25d91d.zip
Move simple Bash/pdksh functions into POSIX sh
Have only translated the scripts that translate readily into POSIX sh for now. More complex stuff like that bd/pd/sd/ud navigation for Bash doesn't port as easily, mostly because there isn't an analogue for the "local" keyword in POSIX.
Diffstat (limited to 'sh/shrc.d/mysql.sh')
-rw-r--r--sh/shrc.d/mysql.sh19
1 files changed, 19 insertions, 0 deletions
diff --git a/sh/shrc.d/mysql.sh b/sh/shrc.d/mysql.sh
new file mode 100644
index 00000000..00b6930c
--- /dev/null
+++ b/sh/shrc.d/mysql.sh
@@ -0,0 +1,19 @@
+# If a file ~/.mysql/$1.cnf exists, call mysql(1) using that file. Otherwise
+# just run MySQL with given args. Use restrictive permissions on these files.
+# Examples:
+#
+# [client]
+# host=dbhost.example.com
+# user=foo
+# password=SsJ2pICe226jM
+#
+# [mysql]
+# database=bar
+#
+mysql() {
+ if [ -f "$HOME"/.mysql/"$1".cnf ] ; then
+ shift
+ set -- --defaults-extra-file="$HOME"/.mysql/"$1".cnf "$@"
+ fi
+ command mysql "$@"
+}