Added support for PostgreSQL; Restore MySQL with UTF8 support

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

diff --git a/NextcloudBackup.sh b/NextcloudBackup.sh
index 469d9d19ed0cddfed69847115bff5e97efa4f455..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,21 +16,23 @@
 # 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/"
-# 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"
 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. 'systemctl start <webserverServiceName>')
+webserverServiceName="nginx"

 # TODO: Your Nextcloud database name
 nextcloudDatabase="nextcloud_db"
 # TODO: Your Nextcloud database user
 dbUser="nextcloud_db_user"
 # TODO: The password of the Nextcloud database user
 dbPassword="mYpAsSw0rd"
 # TODO: Your Nextcloud database name
 nextcloudDatabase="nextcloud_db"
 # TODO: Your Nextcloud database user
 dbUser="nextcloud_db_user"
 # TODO: The password of the Nextcloud database user
 dbPassword="mYpAsSw0rd"

-# TODO: Your webserver user
+# TODO: Your web server user

 webserverUser="www-data"
 # TODO: The maximum number of backups to keep (when set to 0, all backups are kept)
 maxNrOfBackups=0
 webserverUser="www-data"
 # TODO: The maximum number of backups to keep (when set to 0, all backups are kept)
 maxNrOfBackups=0


@@ -44,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
 #


@@ -68,17 +94,15 @@ 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
 
 #

-# Stop webserver
+# Stop web server

 #
 #

-echo "Stopping nginx..."
-service nginx stop
+echo "Stopping web server..."
+systemctl stop "${webserverServiceName}"

 echo "Done"
 echo
 
 echo "Done"
 echo
 


@@ -99,44 +123,43 @@ 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
 
 #

-# Start webserver
+# Start web server

 #
 #

-echo "Starting webserver..."
-service nginx start
+echo "Starting web server..."
+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
 #
 
 #
 # Delete old backups
 #

-if [ ${maxNrOfBackups} != 0 ]
-then   
+if (( ${maxNrOfBackups} != 0 ))
+then

        nrOfBackups=$(ls -l ${backupMainDir} | grep -c ^d)
        nrOfBackups=$(ls -l ${backupMainDir} | grep -c ^d)

-       
-       if [  ${maxNrOfBackups} > ${nrOfBackups}} ]
+
+       if (( ${nrOfBackups} > ${maxNrOfBackups} ))

        then
                echo "Removing old backups..."
                ls -t ${backupMainDir} | tail -$(( nrOfBackups - maxNrOfBackups )) | while read dirToRemove; do
        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