From 8085cbeeeb963d73f46ea4c2097e9cbae3a500a2 Mon Sep 17 00:00:00 2001
From: James Bunton <jamesbunton@delx.net.au>
Date: Sat, 3 Mar 2018 13:50:39 +1100
Subject: [PATCH] backup-mysql

---
 backup-mysql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100755 backup-mysql

diff --git a/backup-mysql b/backup-mysql
new file mode 100755
index 0000000..2b66f0a
--- /dev/null
+++ b/backup-mysql
@@ -0,0 +1,13 @@
+#!/bin/bash
+
+set -eu
+
+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"
+
+    rm -f $(ls -1 "${db}-"* | sort -r | tail -n +10)
+done
-- 
2.39.2