From 92cf76be4ea522691e86b3469527113f63f830bc Mon Sep 17 00:00:00 2001
From: Guillaume Pellerin <guillaume.pellerin@ircam.fr>
Date: Tue, 26 Jan 2016 11:55:27 +0100
Subject: [PATCH] make restore_db universal, add doc

---
 README.rst                | 14 ++++++++++++++
 data/backup/restore_db.sh |  9 ++++++++-
 2 files changed, 22 insertions(+), 1 deletion(-)

diff --git a/README.rst b/README.rst
index df0ec0c9..c7f6a7f7 100644
--- a/README.rst
+++ b/README.rst
@@ -123,6 +123,20 @@ First install `Git <http://git-scm.com/downloads>`_, `Docker <https://docs.docke
 You can now browse http://localhost:8000 to get the web interface.
 
 
+Restore / backup
+================
+
+To restore a backuped database, put your backup file in data/backup, then in another terminal::
+
+    docker-compose run db /srv/backup/restore_db.sh FILENAME
+
+where FILENAME is the backup filename (can be .sql or .sql.gz)
+
+To backup the database, just run in another terminal::
+
+    docker-compose run db /srv/backup/backup_db.sh
+
+
 API / Documentation
 ====================
 
diff --git a/data/backup/restore_db.sh b/data/backup/restore_db.sh
index 1bf4eb3f..8666bf8c 100755
--- a/data/backup/restore_db.sh
+++ b/data/backup/restore_db.sh
@@ -1,3 +1,10 @@
 #!/bin/bash
 
-gunzip < /srv/backup/$1 | mysql -hdb -uroot -pmysecretpassword telemeta
+file=$1
+
+if [[ $file == *".gz" ]]; then
+    echo 'ok'
+    gunzip < /srv/backup/$file | mysql -hdb -uroot -pmysecretpassword telemeta
+else
+    mysql -hdb -uroot -pmysecretpassword telemeta < /srv/backup/$file
+fi
-- 
2.39.5