Skip to content
Snippets Groups Projects

WIP: Resolve "Restore from legacy backup"

Open Michel Memeteau requested to merge 182-restore-from-legacy-backup into master
Compare and Show latest version
2 files
+ 44
16
Compare changes
  • Side-by-side
  • Inline
Files
2
utils/backup_app.sh 100644 → 100755
+ 44
16
@@ -6,7 +6,7 @@
#--- Manage arguments:
case $# in
1) ARG1="$1" ;;
*) echo "Usage: ./backup_piwigo.sh DB_PASSWORD" ;;
*) echo "Usage: ./backup_app.sh APP DB_PASSWORD" ; exit 1;;
esac
#--- Connexion parameters:
@@ -17,7 +17,7 @@ DB_NAME='piwigo'
DB_USER='piwigo'
DB_PWD="$ARG1"
APP=PIWIGO
APP_NAME='piwigo'
#app piwigo directories
APP_DIR='/var/www/photos'
@@ -26,41 +26,71 @@ APP_DATA2='upload' ; # photos/upload
#app prestashop directories
APP_DIR='/var/www/html'
APP_DATA1=
#app nextcloud directories
#--- Beginning backup:
backup_db
backup_piwigo
download_archives
function backup_prestashop ()
function download_archives ()
{
echo "Start backup_prestashop"
echo "Not implemented"
echo "Start downloading archive (be patient)..."
scp -P $HOST_PORT ${HOST_USER}@$HOST_NAME:/${HOST_USER}/${APP_NAME}*.tgz .
echo "Archive ${APP_NAME}*.tgz downloaded!"
ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "rm -f ${APP_NAME}*.tgz"
#-- db archive download in backup_db
}
function backup_piwigo ()
function backup_db ()
{
echo "Start backup_piwigo"
echo "***** Backup $DB_NAME application data *****"
echo ""
#--- Backup database:
#--- 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!"
echo "Database dump downloaded!"
#TODO : Pgsql
}
function backup_prestashop ()
{
echo "Start backup_prestashop"
#--- 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"
ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "cd ${APP_DIR} ; tar czf /${HOST_USER}/${APP_NAME}_${APP_DATA1}.tgz $APP_DATA1"
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"
}
function backup_piwigo ()
{
echo "Start backup_piwigo"
echo "***** Backup $DB_NAME application data *****"
echo ""
#--- Backup data:
echo "*** App data backup from $HOST_NAME to local file ${APP_NAME}.tgz ***"
echo "Build archive on $HOST_NAME..."
ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "cd ${APP_DIR}/_data ; tar czf /${HOST_USER}/${APP_NAME}_${APP_DATA1}mages.tgz $APP_DATA1"
ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "cd ${APP_DIR} ; tar czf /${HOST_USER}/${APP_NAME}_${APP_DATA2}.tgz $APP_DATA2"
echo "Archive built!"
#--- End of tasks:
echo ""
echo "***** End of $DB_NAME backup *****"
@@ -75,7 +105,5 @@ function backup_nextcloud ()
}
#--- Beginning backup:
backup_piwigo
Loading