From cbef0944ce32d4988a70d7d6301dee45989038af Mon Sep 17 00:00:00 2001
From: Guillaume Pellerin <guillaume.pellerin@ircam.fr>
Date: Tue, 26 Jan 2016 11:24:20 +0100
Subject: [PATCH] use .init only for update_index, add DB backup and restore
 scripts

---
 .gitignore                | 4 +++-
 app/deploy/start_app.sh   | 4 ++--
 data/backup/backup_db.sh  | 4 ++++
 data/backup/restore_db.sh | 3 +++
 4 files changed, 12 insertions(+), 3 deletions(-)
 create mode 100755 data/backup/backup_db.sh
 create mode 100755 data/backup/restore_db.sh

diff --git a/.gitignore b/.gitignore
index ce93772b..78da6b0f 100644
--- a/.gitignore
+++ b/.gitignore
@@ -10,7 +10,9 @@ eggs
 parts
 bin
 var
-data
+data/media
+data/var
+data/static
 sdist
 develop-eggs
 .installed.cfg
diff --git a/app/deploy/start_app.sh b/app/deploy/start_app.sh
index 4b626e0a..fc103355 100644
--- a/app/deploy/start_app.sh
+++ b/app/deploy/start_app.sh
@@ -28,11 +28,11 @@ python $app/wait.py
 python $manage syncdb --noinput
 python $manage migrate --noinput
 python $manage collectstatic --noinput
+python $manage telemeta-create-admin-user
+python $manage telemeta-create-boilerplate
 
 if [ ! -f $app/.init ]; then
  chown -R www-data:www-data $media
- python $manage telemeta-create-admin-user
- python $manage telemeta-create-boilerplate
  python $manage update_index --workers $processes &
  touch $app/.init
 fi
diff --git a/data/backup/backup_db.sh b/data/backup/backup_db.sh
new file mode 100755
index 00000000..b28c0f40
--- /dev/null
+++ b/data/backup/backup_db.sh
@@ -0,0 +1,4 @@
+#!/bin/bash
+
+NOW=$(date +"%T-%m-%d-%Y")
+mysqldump -hdb -uroot -pmysecretpassword telemeta | gzip > /srv/backup/telemeta-$NOW.sql.gz
diff --git a/data/backup/restore_db.sh b/data/backup/restore_db.sh
new file mode 100755
index 00000000..1bf4eb3f
--- /dev/null
+++ b/data/backup/restore_db.sh
@@ -0,0 +1,3 @@
+#!/bin/bash
+
+gunzip < /srv/backup/$1 | mysql -hdb -uroot -pmysecretpassword telemeta
-- 
2.39.5