Add script to backup mysql databases.

1 files changed, 16 insertions, 0 deletions

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