From 59616f110b73ac3944bf9c213e76ccce5ca4496d Mon Sep 17 00:00:00 2001
From: Guillaume Pellerin <guillaume.pellerin@ircam.fr>
Date: Tue, 1 Mar 2016 00:58:39 +0100
Subject: [PATCH] add password arg and smart time for restore script

---
 scripts/sql/backup_db.sh  |  6 ++++--
 scripts/sql/restore_db.sh | 13 ++++++++-----
 2 files changed, 12 insertions(+), 7 deletions(-)

diff --git a/scripts/sql/backup_db.sh b/scripts/sql/backup_db.sh
index b28c0f40..d18a0579 100755
--- a/scripts/sql/backup_db.sh
+++ b/scripts/sql/backup_db.sh
@@ -1,4 +1,6 @@
 #!/bin/bash
 
-NOW=$(date +"%T-%m-%d-%Y")
-mysqldump -hdb -uroot -pmysecretpassword telemeta | gzip > /srv/backup/telemeta-$NOW.sql.gz
+PASSWORD=$1
+NOW=$(date +"%Y-%m-%d-%T")
+
+mysqldump -hdb -uroot -p$PASSWORD telemeta | gzip > /srv/backup/telemeta-$NOW.sql.gz
diff --git a/scripts/sql/restore_db.sh b/scripts/sql/restore_db.sh
index 8666bf8c..be4cd5ba 100755
--- a/scripts/sql/restore_db.sh
+++ b/scripts/sql/restore_db.sh
@@ -1,10 +1,13 @@
 #!/bin/bash
 
-file=$1
+PASSWORD=$1
+DIR=/srv/backup/
+FILE=`ls -t $DIR/*.sql* | head -1`
 
-if [[ $file == *".gz" ]]; then
-    echo 'ok'
-    gunzip < /srv/backup/$file | mysql -hdb -uroot -pmysecretpassword telemeta
+if [[ $FILE == *".gz" ]]; then
+    gunzip < $FILE | mysql -hdb -uroot -p$PASSWORD telemeta
 else
-    mysql -hdb -uroot -pmysecretpassword telemeta < /srv/backup/$file
+    mysql -hdb -uroot -p$PASSWORD telemeta < $FILE
 fi
+
+echo "backup restored : "$FILE
-- 
2.39.5