## Restore
-Principle:
-
-1. Remove DB content (but keep schema structure)
-2. Import DB data
-3. Save `webroot/files` directory
-4. From `webroot` directory, extract dump of `files`
-
-Let say dump files are located in `/tmp/` and named:
-
-* `SAVE_COMPTOIR_<TIMESTAMP>_Data_only.sql.bz2` for DB content
-* `SAVE_COMPTOIR_<TIMESTAMP>_Dir_Files.tar.bz2` for `files` directory
-
-Say
-
-```sh
-TIMESTAMP="2016-06-28-15h06m42"
-```
-
-From the directory containing all Comptoir-SRV code, do:
-
-```shell
-psql -U comptoir -W -f config/SQL/COMPTOIR_Purge_tables_content.sql
-bunzip2 /tmp/SAVE_COMPTOIR_${TIMESTAMP}_Data_only.sql.bz2
-psql -U comptoir -W -f /tmp/SAVE_COMPTOIR_${TIMESTAMP}_Data_only.sql
-cd webroot
-sudo mv files/ files-tmp/
-sudo tar xvfj /tmp/SAVE_COMPTOIR_${TIMESTAMP}_Dir_Files.tar.bz2
-sudo chgrp -R www-data files/
-find . files/ -type f -exec sudo chmod 664 {} \;
-find . files/ -type d -exec sudo chmod 775 {} \;
-```
-
-Verify in the app everything is OK, then `sudo rm -rf files-tmp/`
+Follow help from file `bin/COMPTOIR_import_DB_data_AND_images.sh`
--- /dev/null
+#!/usr/bin/env bash
+
+set -o errexit
+
+# #############################################################################
+# Option management
+# #############################################################################
+
+TEMP=`getopt -o d:t: -- "$@"`
+
+if [ $? != 0 ] ; then echo "Terminating..." >&2 ; exit 1 ; fi
+
+usage () {
+ echo 'usage: ./COMPTOIR_import_DB_data_AND_images.sh [OPTIONS]...'
+ echo ''
+ echo ' -d <comptoir-srv-dir> (MANDATORY) Absolute directory to Comptoir-srv, *without* trailing slash, eg "/home/comptoir/comptoir-srv"'
+ echo ' -t <timestamp> (MANDATORY) Timestamp of the files to import, eg "2016-06-28-15h06m42"'
+ echo ''
+ exit 2
+}
+
+# Note the double quotes around $TEMP: they are essential!
+eval set -- "${TEMP}"
+
+declare COMPTOIR_SRV_DIR=
+declare TIMESTAMP=
+
+while true; do
+ case "$1" in
+ -d ) COMPTOIR_SRV_DIR="$2"; shift 2 ;;
+ -t ) TIMESTAMP="$2"; shift 2 ;;
+ -- ) shift; break ;;
+ * ) break ;;
+ esac
+done
+
+# check mandatory options
+if [ "${COMPTOIR_SRV_DIR}" = "" -o "${TIMESTAMP}" = "" ]
+then
+ echo ''
+ echo 'Mandatory option is missing'
+ echo ''
+ usage
+fi
+
+# #############################################################################
+# Variables
+# #############################################################################
+
+DUMP_PATH=/tmp
+SAVE_SQL_FILE="${DUMP_PATH}/SAVE_COMPTOIR_${TIMESTAMP}_Data_only.sql"
+SAVE_WEBROOT_FILES_FILE="${DUMP_PATH}/SAVE_COMPTOIR_${TIMESTAMP}_Dir_Files.tar.bz2"
+
+# #############################################################################
+# Actual import
+# #############################################################################
+
+psql -U comptoir -W -f "${COMPTOIR_SRV_DIR}/config/SQL/COMPTOIR_Purge_tables_content.sql"
+bunzip2 "${SAVE_SQL_FILE}.bz2"
+psql -U comptoir -W -f "${SAVE_SQL_FILE}"
+cd "${COMPTOIR_SRV_DIR}/webroot"
+sudo mv files/ files-tmp/
+sudo tar xvfj "${SAVE_WEBROOT_FILES_FILE}"
+sudo chgrp -R www-data files/
+find . files/ -type f -exec sudo chmod 664 {} \;
+find . files/ -type d -exec sudo chmod 775 {} \;
+
+echo ""
+echo "Please, verify in the app everything is OK"
+echo "then do: sudo rm -rf \"${COMPTOIR_SRV_DIR}/webroot/files-tmp/\""
+echo ""