backup-mysql.sh

#!/bin/bash -eu
# Dump all mysql databases in to separate files

# config
user=backup-db
dir=/home/backup-db/data/mysql

# runtime variables
ts=$(date +%Y%m%d%H%M%S)
dbs=$(sudo -i -u ${user} mysql -N -r -s -e 'SHOW DATABASES' | egrep -v '^information_schema|performance_schema$')

sudo -u ${user} mkdir -p ${dir}

for db in ${dbs}; do
  sudo -i -u ${user} sh -c "mysqldump -xQce --events  $db | gzip > ${dir}/${db}.${ts}.sql.gz"
done