docker nextcloud backup / restore

nextcloud-docker-backup.sh

#!/usr/bin/env bash
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"
TIMESTAMP=`date +"%Y-%m-%d-%T"`
BACKUP_DIR="${DIR}/${TIMESTAMP}"
APPDATA_DIR="${DIR}/../appdata"

MYSQL_USER="root"
MYSQL_PASSWORD="abc123"
MYSQL_DB="nextcloud_db"

if [[ ! $UID -eq 0 ]];
then
	echo "Please run this script as root"
	exit 1
fi

# UNLOCK
chattr -i .

# CREATE BACKUP DIR
mkdir $BACKUP_DIR

# TURN ON MAINTAINENCE MODE
docker exec --user abc nextcloud /config/www/nextcloud/occ maintenance:mode --on

# SQL BACKUP
docker exec nextcloudsql mysqldump --single-transaction --host=localhost --user=${MYSQL_USER} --password=${MYSQL_PASSWORD} ${MYSQL_DB} > "$BACKUP_DIR/${MYSQL_DB}.sql"

# APPDATA BACKUP
rsync --quiet -a -zz "${APPDATA_DIR}" "${BACKUP_DIR}"

# COMPRESS BACKUP
sudo tar -czf "./${TIMESTAMP}.tar.gz" ${BACKUP_DIR}

# REMOVE UNCOMPRESSED DIR
rm -rf $BACKUP_DIR

# TURN OFF MAINTAINENCE MODE
docker exec --user abc nextcloud /config/www/nextcloud/occ maintenance:mode --off

# REMOVE OLD BACKUPS
find . -maxdepth 1 -iname "*.tar.gz" -mtime +30 -exec rm {} \;

# LOCK
chattr +i .

nextcloud-docker-restore.sh

#!/usr/bin/env bash
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"
BACKUP_FILE="${DIR}/backup.sh"
SQL_FILE="${DIR}/restore.sql"

MYSQL_PASSWORD="abc123"
MYSQL_DB="nextcloud_db"

if [[ ! $UID -eq 0 ]];
then
	echo "Please run this script as root"
	exit 1
fi

if [[ ! -e $SQL_FILE ]];
then
	echo "NOT FOUND: $SQL_FILE"
	echo "Please please a restore.sql file in the current directory before running this script."
	exit 1
fi

# BACKUP FIRST
echo "Backing up Nextcloud before restoring . . ."
sudo $BACKUP_FILE

# UNLOCK
chattr -i .

# TURN ON MAINTAINENCE MODE
docker exec --user abc nextcloud /config/www/nextcloud/occ maintenance:mode --on

# SQL RESTORE
cat $SQL_FILE | docker exec -i nextcloudsql mysql --password="$MYSQL_PASSWORD" "$MYSQL_DB"

# TURN OFF MAINTAINENCE MODE
docker exec --user abc nextcloud /config/www/nextcloud/occ maintenance:mode --off

# LOCK
chattr +i .