From 7054dc69613f47d2b68dbca06f4895fe52412f7c Mon Sep 17 00:00:00 2001
From: David Runge <dave@sleepmap.de>
Date: Fri, 20 Mar 2015 01:07:55 +0100
Subject: backup-mariadb: Adding first version of backup-mariadb script,
 service and timer.

---
 scripts/backup-mariadb | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100755 scripts/backup-mariadb

(limited to 'scripts/backup-mariadb')

diff --git a/scripts/backup-mariadb b/scripts/backup-mariadb
new file mode 100755
index 0000000..ae5d0ec
--- /dev/null
+++ b/scripts/backup-mariadb
@@ -0,0 +1,30 @@
+#!/usr/bin/env bash
+
+# Set required settings
+timestamp="$(date +"%Y%m%d-%H%M%S")-"
+
+# If the backup location doesn't exist yet, create it
+if [ ! -d $mariadb_folder_destination ]; then
+  mkdir -p $mariadb_folder_destination
+fi
+
+# Get the names of all databases
+databases=`mysql --user=$mariadb_user -p$mariadb_password -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema|tmp)"`
+
+cd $tmp
+# Iterate over all database names and create a backup for each, encrypting them afterwards
+for db in $databases; do
+  echo "$db -> $mariadb_folder_destination$timestamp$db$sql_suffix$tar_suffix$gpg_suffix"
+  # dump .sql to /tmp
+  mysqldump --force --opt --user=$mariadb_user -p$mariadb_password --databases $db > $tmp$timestamp$db$sql_suffix
+  # tar in /tmp
+  tar cfJ $timestamp$db$sql_suffix$tar_suffix $timestamp$db$sql_suffix
+  # gpg to mariadb_folder_destination
+  gpg -e \
+    -r "$gpg_public_key" \
+    -o $mariadb_folder_destination$timestamp$db$sql_suffix$tar_suffix$gpg_suffix \
+    $timestamp$db$sql_suffix$tar_suffix
+  # delete tar and sql in /tmp
+  rm -f $timestamp$db$sql_suffix*
+done
+
-- 
cgit v1.2.3-70-g09d2