From a29ec21bcdb5d11b9807f4aa79fa4684a715bee0 Mon Sep 17 00:00:00 2001
From: lookshe <github@lookshe.org>
Date: Mon, 6 Oct 2014 12:11:56 +0200
Subject: some comments

---
 backup_db.sh | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

diff --git a/backup_db.sh b/backup_db.sh
index 76c06bc..2562695 100755
--- a/backup_db.sh
+++ b/backup_db.sh
@@ -4,6 +4,8 @@
 # main configuration
 script_dir="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
 config_file="$script_dir/main.cfg"
+
+# remote and local directories
 db_dir="$script_dir/db"
 backupdirsingle=db
 
@@ -24,7 +26,7 @@ function source_section {
    rm -f "$tmp_file"
 }
 
-# copy file with rsync to server and save last timestamp to logfile
+# copy file with rsync to server
 function rsync_server {
    filefrom="$1"
    dirto="$2"
@@ -41,11 +43,16 @@ function rsync_server {
 # general section from main config
 source_section "$config_file" "general"
 
+# change folder for temporary storage
 cd "$db_dir"
 
+# get all databases
 databases=$(nice -n 19 mysql -u root -N -e "show databases;" | grep -v "^information_schema$" | grep -v "^mysql$")
+
+# handle each database
 for database in $databases
 do
+   # dump and gzip database
    nice -n 19 mysqldump -u root "$database" > "$database.sql"
    nice -n 19 gzip "$database.sql"
 
@@ -67,5 +74,6 @@ do
 
    rsync_server "$database.sql.gz" "$backupdir/$backupdirsingle/"
 
+   # delete temporary file
    rm -f "$database.sql.gz"
-done
+done # for database in $databases
-- 
cgit v1.2.3