--- /dev/null
+#!/bin/bash
+
+set -eu
+
+cd ~/backup-mysql/
+
+DATABASES="$(echo 'show databases' | mysql | grep -vE '^(Database|mysql|information_schema|performance_schema)$')"
+for db in ${DATABASES}; do
+ mysqldump --add-drop-table --single-transaction "${db}" | \
+ gzip -9 > "${db}-$(date '+%Y%m%d').sql.gz"
+
+ rm -f $(ls -1 "${db}-"* | sort -r | tail -n +10)
+done