From 5018d9f3aadfcbbac3c41c142fc2a29caac38b12 Mon Sep 17 00:00:00 2001
From: Horus3
Date: Wed, 25 Mar 2015 18:02:11 +0100
Subject: Add script to backup mysql databases.

---
 bin/backup_mysql.sh | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100755 bin/backup_mysql.sh

diff --git a/bin/backup_mysql.sh b/bin/backup_mysql.sh
new file mode 100755
index 0000000..eea03bd
--- /dev/null
+++ b/bin/backup_mysql.sh
@@ -0,0 +1,16 @@
+#!/bin/bash
+# Backup all databases in a MySQL or MariaDB server.
+
+password="$1"
+
+if [ -z $password ]; then
+	echo "Usage: $0 MYSQL_ROOT_PASSWORD" 1>&2
+	exit 1
+fi
+
+for i in $(mysql -u root -p${password} -e "show databases;" | grep -E '\w' | tail -n +2); do
+	if [[ $i != "information_schema" ]]; then
+		echo "Doing backup for database $i..."
+		mysqldump -u root -p${password} $i > $i.sql
+	fi
+done
-- 
cgit v1.2.3