From: James Bunton Date: Sun, 11 Jun 2017 15:39:21 +0000 (+1000) Subject: backup-mysql: fixed directory X-Git-Url: https://code.delx.au/monosys/commitdiff_plain/436ce974d1bb902dfab9e52a5f791037d9052445 backup-mysql: fixed directory --- diff --git a/backup-mysql b/backup-mysql index fa86056..2b66f0a 100755 --- a/backup-mysql +++ b/backup-mysql @@ -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"