From 7054dc69613f47d2b68dbca06f4895fe52412f7c Mon Sep 17 00:00:00 2001 From: David Runge 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') 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-54-g00ecf