WIP: Resolve "Restore from legacy backup"

Closes #182

utils/backup_app.sh

 #!/bin/bash
 
-#=== Informations ===================================================================#
-#- Backup App (Piwigo, prestashop, nextcloud) database and data files
+#=== Informations ================================================================#
+#- Goal: backup App (Piwigo, prestashop, nextcloud) database and data files
 #- Author: B. Mauclaire - bm@ekimia.fr - 2019/11/11
 #- Author: M. Memeteau - mm@ekimia.fr - 2020/01/01
 #- Licence: GNU Affero General Public License v3.0
@@ -63,7 +63,7 @@ function set_app_directories ()
       piwigo)
          #-- i=photos/_data/i ; upload=photos/upload
          APP_DIR="/var/www/photos" ;
-         APP_DIRS=( "_data/i" "upload" ) ;
+         APP_DIRS=( "_data/i" "upload" "local/config" ) ;
       ;;
       prestashop)
          APP_DIR="/var/www/html" ;
@@ -124,14 +124,18 @@ function backup_db ()
 {
    echo ""
    echo "*** Database backup from $HOST_NAME to local file ${DB_NAME}.sql ***"
-   
-   if [ "$DB_ENGINE" == "mysql" ] || [ "$DB_ENGINE" == "mariadb" ] ; then
-      $SSHNOPASS "mysqldump '"$DB_NAME"' -u '"$DB_USER"' -p'"${DB_PWD}"'" > ${DB_NAME}.sql
-   elif [ "$DB_ENGINE" == "pgsql" ] ; then
-      # !! TO TEST !!
-      $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump --format=plain--file --create -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
-      # pg_dump postgresql://username:password@127.0.0.1:5432/mydatabase 
-   fi
+
+   case $DB_ENGINE in
+      "mysql" | "mariadb")
+         $SSHNOPASS "mysqldump '"$DB_NAME"' -u '"$DB_USER"' -p'"${DB_PWD}"'" > ${DB_NAME}.sql
+         ;;
+      "pgsql")
+         #- !! TO TEST !!
+         # $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump --format=plain--file --create -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
+         $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump -F p -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
+         # pg_dump postgresql://username:password@127.0.0.1:5432/mydatabase 
+         ;;
+   esac
    
    echo "*** Database dump downloaded! ***"
 }