]> code.delx.au - monosys/commitdiff
backup-mysql: fixed directory
authorJames Bunton <jamesbunton@delx.net.au>
Sun, 11 Jun 2017 15:39:21 +0000 (01:39 +1000)
committerJames Bunton <jamesbunton@delx.net.au>
Sun, 11 Jun 2017 15:39:21 +0000 (01:39 +1000)
backup-mysql

index fa860568375d12e62d185f08b0dba6e344cdbd8b..2b66f0a8b8c0f1f8b6952e655d46f857d33a10e8 100755 (executable)
@@ -1,9 +1,10 @@
 #!/bin/bash
 
-DATABASES="$(echo 'show databases' | mysql | tail -n+2)"
+set -eu
 
-cd ~/backup
+cd ~/backup-mysql/
 
+DATABASES="$(echo 'show databases' | mysql | tail -n+2)"
 for db in ${DATABASES}; do
     mysqldump --add-drop-table --single-transaction "${db}" | \
         gzip -9 > "${db}-$(date '+%Y%m%d').sql.gz"