Support for PostgreSQL

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

diff --git a/NextcloudBackup.sh b/NextcloudBackup.sh
index 6f09159f9d43e13fdcbcc7d28a13ea4cfe842dd6..3e08cb4151dde6690d07ec1e26f034a47968105e 100644 (file)
--- a/NextcloudBackup.sh
+++ b/NextcloudBackup.sh
@@ -3,8 +3,8 @@
 #
 # Bash script for creating backups of Nextcloud.
 # Usage: ./NextcloudBackup.sh
 #
 # 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,7 +16,7 @@
 # Variables
 currentDate=$(date +"%Y%m%d_%H%M%S")
 # TODO: The directory where you store the Nextcloud backups
 # Variables
 currentDate=$(date +"%Y%m%d_%H%M%S")
 # TODO: The directory where you store the Nextcloud backups

-backupMainDir="/mnt/Share/NextcloudBackups/"
+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)
 # 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)


@@ -24,7 +24,7 @@ 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 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"
 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 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
 #
 #
 # Check for root
 #


@@ -70,9 +94,7 @@ fi
 # Set maintenance mode
 #
 echo "Set maintenance mode for Nextcloud..."
 # 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
 
 echo "Done"
 echo
 


@@ -80,7 +102,7 @@ echo
 # Stop web server
 #
 echo "Stopping web server..."
 # Stop web server
 #
 echo "Stopping web server..."

-service "${webserverServiceName}" stop
+systemctl stop "${webserverServiceName}"

 echo "Done"
 echo
 
 echo "Done"
 echo
 


@@ -101,7 +123,11 @@ echo
 # Backup DB
 #
 echo "Backup Nextcloud database..."
 # Backup DB
 #
 echo "Backup Nextcloud database..."

+# MySQL/MariaDB:

 mysqldump --single-transaction -h localhost -u "${dbUser}" -p"${dbPassword}" "${nextcloudDatabase}" > "${backupdir}/${fileNameBackupDb}"
 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
 
 echo "Done"
 echo
 


@@ -109,36 +135,31 @@ echo
 # Start web server
 #
 echo "Starting web server..."
 # Start web server
 #
 echo "Starting web server..."

-service "${webserverServiceName}" start
+systemctl start "${webserverServiceName}"

 echo "Done"
 echo
 
 #
 # Disable maintenance mode
 #
 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 ))
 
 #
 # Delete old backups
 #
 if (( ${maxNrOfBackups} != 0 ))

-then   
+then

        nrOfBackups=$(ls -l ${backupMainDir} | grep -c ^d)
        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
        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
 
        fi
 fi