Utility scripts for Nextcloud & MySQL/MariaDB maintenance

nextcloud-manual-update.sh

#!/bin/bash

##Turn on maintenance mode
docker exec -it nextcloud occ maintenance:mode --on

##Backup current nextcloud install
docker exec -it nextcloud mv /config/www/nextcloud /config/www/nextcloud-backup

##Grab newest nextcloud release and unpack it
docker exec -it nextcloud wget https://download.nextcloud.com/server/releases/latest.tar.bz2 -P /config
docker exec -it nextcloud tar -xvf /config/latest.tar.bz2 -C /config/www

##Copy across old config.php from backup
docker exec -it nextcloud cp /config/www/nextcloud-backup/config/config.php /config/www/nextcloud/config/config.php

##Now Restart docker container
docker restart nextcloud

##Perform upgrade
docker exec -it nextcloud occ upgrade

##Turn off maintenance mode
docker exec -it nextcloud occ maintenance:mode --off

## Now Restart docker container
docker restart nextcloud

nextcloud-mysql-backup.sh

#!/bin/bash
mysqldump --single-transaction -h [server] -u [username] -p"[password]" [db_name] > nextcloud-sqlbkp_`date +"%Y%m%d"`.bak

nextcloud-update-clean.sh

#!/bin/bash

##Remove  backup folder
docker exec -it nextcloud rm -rf /config/www/nextcloud-backup

##Remove Nextcloud tar file
docker exec -it nextcloud rm /config/latest.tar.bz2