Added support for PostgreSQL; Restore MySQL with UTF8 support

[nextcloud-backup-restore.git] / NextcloudBackup.sh

diff --git a/NextcloudBackup.sh b/NextcloudBackup.sh
index dae6e7faf489533826c9573910186791254602d7..3e08cb4151dde6690d07ec1e26f034a47968105e 100644 (file)
--- a/NextcloudBackup.sh
+++ b/NextcloudBackup.sh
@@ -3,8 +3,8 @@
 #
 # Bash script for creating backups of Nextcloud.
 # Usage: ./NextcloudBackup.sh
-# 
-# The script is based on an installation of Nextcloud using nginx and MariaDB, see https://decatec.de/home-server/nextcloud-auf-ubuntu-server-mit-nginx-mariadb-php-lets-encrypt-redis-und-fail2ban/
+#
+# The script is based on an installation of Nextcloud using nginx and MariaDB, see https://decatec.de/home-server/nextcloud-auf-ubuntu-server-18-04-lts-mit-nginx-mariadb-php-lets-encrypt-redis-und-fail2ban/
 #
 
 #
@@ -16,15 +16,15 @@
 # Variables
 currentDate=$(date +"%Y%m%d_%H%M%S")
 # TODO: The directory where you store the Nextcloud backups
-backupMainDir="/mnt/Share/NextcloudBackups/"
-# The actual directory of the current backup - this is is subdirectory of the main directory above with a timestamp
+backupMainDir="/mnt/Share/NextcloudBackups"
+# The actual directory of the current backup - this is a subdirectory of the main directory above with a timestamp
 backupdir="${backupMainDir}/${currentDate}/"
 # TODO: The directory of your Nextcloud installation (this is a directory under your web root)
 nextcloudFileDir="/var/www/nextcloud"
 # TODO: The directory of your Nextcloud data directory (outside the Nextcloud file directory)
 # If your data directory is located under Nextcloud's file directory (somewhere in the web root), the data directory should not be a separate part of the backup
 nextcloudDataDir="/var/nextcloud_data"
-# TODO: The service name of the web server. Used to start/stop web server (e.g. 'service <webserverServiceName> start')
+# TODO: The service name of the web server. Used to start/stop web server (e.g. 'systemctl start <webserverServiceName>')
 webserverServiceName="nginx"
 # TODO: Your Nextcloud database name
 nextcloudDatabase="nextcloud_db"
@@ -46,6 +46,30 @@ fileNameBackupDb="nextcloud-db.sql"
 # Function for error messages
 errorecho() { cat <<< "$@" 1>&2; }
 
+function DisableMaintenanceMode() {
+       echo "Switching off maintenance mode..."
+       sudo -u "${webserverUser}" php ${nextcloudFileDir}/occ maintenance:mode --off
+       echo "Done"
+       echo
+}
+
+# Capture CTRL+C
+trap CtrlC INT
+
+function CtrlC() {
+       read -p "Backup cancelled. Keep maintenance mode? [y/n] " -n 1 -r
+       echo
+
+       if ! [[ $REPLY =~ ^[Yy]$ ]]
+       then
+               DisableMaintenanceMode
+       else
+               echo "Maintenance mode still enabled."
+       fi
+
+       exit 1
+}
+
 #
 # Check for root
 #
@@ -70,9 +94,7 @@ fi
 # Set maintenance mode
 #
 echo "Set maintenance mode for Nextcloud..."
-cd "${nextcloudFileDir}"
-sudo -u "${webserverUser}" php occ maintenance:mode --on
-cd ~
+sudo -u "${webserverUser}" php ${nextcloudFileDir}/occ maintenance:mode --on
 echo "Done"
 echo
 
@@ -80,7 +102,7 @@ echo
 # Stop web server
 #
 echo "Stopping web server..."
-service "${webserverServiceName}" stop
+systemctl stop "${webserverServiceName}"
 echo "Done"
 echo
 
@@ -101,7 +123,11 @@ echo
 # Backup DB
 #
 echo "Backup Nextcloud database..."
+# MySQL/MariaDB:
 mysqldump --single-transaction -h localhost -u "${dbUser}" -p"${dbPassword}" "${nextcloudDatabase}" > "${backupdir}/${fileNameBackupDb}"
+
+# PostgreSQL (uncomment if you are using PostgreSQL as Nextcloud database)
+#PGPASSWORD="${dbPassword}" pg_dump "${nextcloudDatabase}" -h localhost -U "${dbUser}" -f "${backupdir}/${fileNameBackupDb}"
 echo "Done"
 echo
 
@@ -109,36 +135,31 @@ echo
 # Start web server
 #
 echo "Starting web server..."
-service "${webserverServiceName}" start
+systemctl start "${webserverServiceName}"
 echo "Done"
 echo
 
 #
 # Disable maintenance mode
 #
-echo "Switching off maintenance mode..."
-cd "${nextcloudFileDir}"
-sudo -u "${webserverUser}" php occ maintenance:mode --off
-cd ~
-echo "Done"
-echo
+DisableMaintenanceMode
 
 #
 # Delete old backups
 #
 if (( ${maxNrOfBackups} != 0 ))
-then   
+then
        nrOfBackups=$(ls -l ${backupMainDir} | grep -c ^d)
-       
+
        if (( ${nrOfBackups} > ${maxNrOfBackups} ))
        then
                echo "Removing old backups..."
                ls -t ${backupMainDir} | tail -$(( nrOfBackups - maxNrOfBackups )) | while read dirToRemove; do
-               echo "${dirToRemove}"
-               rm -r ${backupMainDir}/${dirToRemove}
-               echo "Done"
-               echo
-    done
+                       echo "${dirToRemove}"
+                       rm -r ${backupMainDir}/${dirToRemove}
+                       echo "Done"
+                       echo
+               done
        fi
 fi