#!/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"