WIP: Resolve "Restore from legacy backup"

Closes #182

utils/backup_piwigo.sh

+#!/bin/bash
+#- Backup App (Piwigo) database and data files
+#- Author: B. Mauclaire - bm@ekimia.fr - 2019/11/11
+#- Usage: vm archive's name will be built with the database's name
+
+#--- Manage arguments:
+case $# in
+   1) ARG1="$1" ;;
+   *) echo "Usage: ./backup_piwigo.sh DB_PASSWORD" ;;
+esac
+
+#--- Connexion parameters:
+HOST_NAME='jaguar.ekimia.fr'
+HOST_USER='root'
+HOST_PORT=622
+DB_NAME='piwigo'
+DB_USER='piwigo'
+DB_PWD="$ARG1"
+APP_DIR='/var/www/photos'
+APP_DATA1='i' ; # photos/_data/i
+APP_DATA2='upload' ; # photos/upload
+
+#--- Beginning backup:
+echo "***** Backup $DB_NAME application data *****"
+echo ""
+
+#--- Backup database:
+echo "*** Database backup from $HOST_NAME to local file ${DB_NAME}.sql ***"
+ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "mysqldump '"$DB_NAME"' -u '"$DB_USER"' -p'"${DB_PWD}"'" > ${DB_NAME}.sql
+echo "Database dump uploaded!"
+
+#--- Backup data:
+echo "*** App data backup from $HOST_NAME to local file ${DB_NAME}.tgz ***"
+echo "Build archive on $HOST_NAME..."
+ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "cd ${APP_DIR}/_data ; tar czf /${HOST_USER}/${DB_NAME}_${APP_DATA1}mages.tgz $APP_DATA1"
+ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "cd ${APP_DIR} ; tar czf /${HOST_USER}/${DB_NAME}_${APP_DATA2}.tgz $APP_DATA2"
+echo "Archive built!"
+echo "Start downloading archive (be patient)..."
+scp -P $HOST_PORT ${HOST_USER}@$HOST_NAME:/${HOST_USER}/${DB_NAME}*.tgz .
+echo "Archive ${DB_NAME}*.tgz downloaded!"
+ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "rm -f ${DB_NAME}*.tgz"
+
+#--- End of tasks:
+echo ""
+echo "***** End of $DB_NAME backup *****"