Create backup.sh

1 files changed, 44 insertions, 0 deletions

diff --git a/backup.sh b/backup.sh
new file mode 100644
index 0000000..789e8a3
--- /dev/null
+++ b/backup.sh
@@ -0,0 +1,44 @@
+#!/bin/bash
+# used to prefix tarsnaps and email reports
+tag="ngha.ro"
+
+tarsnap=/usr/local/bin/tarsnap
+sites=(ngha.ro example.com example.org)
+dirs=(
+    /etc/
+    /root
+    /var/www
+)
+log=$(mktemp)
+mail_to="foo@example.com"
+mail_subject="[${tag}] Backup results"
+
+sql_dump() {
+    local site="$1"
+    local db="${site%.*}"
+    local dump="/var/www/${site}/${db}.sql"
+
+    printf "Dumping MySQL database '%s' to %s ... " "$db" "$dump"
+    mysqldump -R -u USER -pPASSWORD "$db" > "$dump"
+    ret_code=$?
+    chown root:root "$dump"
+    chmod 0600 "$dump"
+
+    result="OK"
+        [[ $req_code -eq 0 ]] || result="FAIL"
+    printf "%s\n" "$result"
+
+    return $ret_code
+}
+
+for site in "${sites[@]}"; do
+    sql_dump $site >> "$log" 2>&1 || mail_subject="${mail_subject} [SQL FAILURES]"
+done
+
+$tarsnap -c -f "${tag}-$(date +%d%m%y_%H:%M)" "${dirs[@]}" 2>&1 \
+    | tee -a "$log" | logger -t backup
+
+[[ ${PIPESTATUS[0]} -eq 0 ]] || mail_subject="${mail_subject} [TARSNAP FAILURES]"
+mail -s "$mail_subject" "$mail_to" < "$log"
+
+rm "$log"