From f3919806db267dfcdf4bc12e86dc9d4e34484ed8 Mon Sep 17 00:00:00 2001
From: Guillaume Pellerin <guillaume.pellerin@ircam.fr>
Date: Wed, 8 Jun 2016 22:40:36 +0200
Subject: [PATCH] improve backup / restore scripts

---
 scripts/sql/backup_db.sh  | 8 +++++++-
 scripts/sql/restore_db.sh | 4 +++-
 2 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/scripts/sql/backup_db.sh b/scripts/sql/backup_db.sh
index 28bc08db..3722e619 100755
--- a/scripts/sql/backup_db.sh
+++ b/scripts/sql/backup_db.sh
@@ -1,5 +1,11 @@
 #!/bin/bash
 
+DIR=/srv/backup/
 NOW=$(date +"%Y-%m-%d-%T")
+FILE=telemeta-$NOW.sql.gz
 
-mysqldump -hdb -uroot -p$MYSQL_ROOT_PASSWORD telemeta | gzip > /srv/backup/telemeta-$NOW.sql.gz
+echo "Backuping: "$FILE
+
+mysqldump -hdb -uroot -p$MYSQL_ROOT_PASSWORD telemeta | gzip > $DIR$FILE
+
+echo "Done!"
diff --git a/scripts/sql/restore_db.sh b/scripts/sql/restore_db.sh
index a0689baa..8a8fd6b6 100755
--- a/scripts/sql/restore_db.sh
+++ b/scripts/sql/restore_db.sh
@@ -3,10 +3,12 @@
 DIR=/srv/backup/
 FILE=`ls -t $DIR/*.sql* | head -1`
 
+echo "Restoring: "$FILE
+
 if [[ $FILE == *".gz" ]]; then
     gunzip < $FILE | mysql -hdb -uroot -p$MYSQL_ROOT_PASSWORD telemeta
 else
     mysql -hdb -uroot -p$MYSQL_ROOT_PASSWORD telemeta < $FILE
 fi
 
-echo "backup restored : "$FILE
+echo "Done!"
-- 
2.39.5