backup-mariadb: Adding first version of backup-mariadb script, service and timer.

1 files changed, 30 insertions, 0 deletions

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
+