From 8e222cf348749ae919415459299b8a9c893d7c41 Mon Sep 17 00:00:00 2001
From: Emilie Zawadzki <emilie.zawadzki@ircam.fr>
Date: Mon, 30 Mar 2020 17:27:01 +0200
Subject: [PATCH] Add specific scripts for mysql based on docker image
 documentation

---
 mysql/backup.sh     |  3 +++
 mysql/push_data.sh  | 15 +++++++++++++++
 mysql/restore_db.sh |  3 +++
 3 files changed, 21 insertions(+)
 create mode 100755 mysql/backup.sh
 create mode 100755 mysql/push_data.sh
 create mode 100755 mysql/restore_db.sh

diff --git a/mysql/backup.sh b/mysql/backup.sh
new file mode 100755
index 0000000..965bacd
--- /dev/null
+++ b/mysql/backup.sh
@@ -0,0 +1,3 @@
+#!/bin/bash
+
+docker-compose exec db bash -c 'mysqldump  --add-drop-database --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD" | gzip > /srv/backup/mysql.sql.gz' 
diff --git a/mysql/push_data.sh b/mysql/push_data.sh
new file mode 100755
index 0000000..ef8931b
--- /dev/null
+++ b/mysql/push_data.sh
@@ -0,0 +1,15 @@
+#!/bin/bash
+
+cd "$(dirname "$0")"/../../
+
+echo "----------------------------"
+echo `date +\%Y\%m\%d-\%H-\%M-\%S`
+
+./bin/mysql/backup.sh
+
+cd "$(dirname "$0")"/../../var
+
+git add .
+git commit -a -m "update DB and media"
+git pull
+git push
diff --git a/mysql/restore_db.sh b/mysql/restore_db.sh
new file mode 100755
index 0000000..45d75d9
--- /dev/null
+++ b/mysql/restore_db.sh
@@ -0,0 +1,3 @@
+#!/bin/sh
+
+docker-compose exec -T db bash -c 'gunzip < /srv/backup/mysql.sql.gz | mysql -uroot -p"$MYSQL_ROOT_PASSWORD"'
-- 
2.39.5