#!/usr/bin/env bash for DATABASE in $(mysql -NBqe 'show databases' | grep -Ev "(information_schema|performance_schema)"); do mysqldump --events ${DATABASE} | gzip > /srv/backup/$(date +%Y%m%d_%H%M)_${DATABASE}.gz; done