X-Git-Url: https://git.p6c8.net/nextcloud-backup-restore.git/blobdiff_plain/f80d5db25b12eec536b3f16e53556bab7b8461c8..f395f5b42b48e79f53cd123946923934cc91a3c9:/NextcloudBackup.sh?ds=inline

diff --git a/NextcloudBackup.sh b/NextcloudBackup.sh
index f433a8d..8c578d0 100644
--- a/NextcloudBackup.sh
+++ b/NextcloudBackup.sh
@@ -2,6 +2,9 @@
 
 #
 # Bash script for creating backups of Nextcloud.
+#
+# Version 1.0.0
+#
 # Usage:
 # 	- With backup directory specified in the script:  ./NextcloudBackup.sh
 # 	- With backup directory specified by parameter: ./NextcloudBackup.sh <BackupDirectory> (e.g. ./NextcloudBackup.sh /media/hdd/nextcloud_backup)
@@ -20,7 +23,7 @@ backupMainDir=$1
 
 if [ -z "$backupMainDir" ]; then
 	# TODO: The directory where you store the Nextcloud backups (when not specified by args)
-    backupMainDir="/media/hdd/nextcloud_backup"
+    backupMainDir='/media/hdd/nextcloud_backup'
 fi
 
 echo "Backup directory: $backupMainDir"
@@ -31,43 +34,46 @@ currentDate=$(date +"%Y%m%d_%H%M%S")
 backupdir="${backupMainDir}/${currentDate}/"
 
 # TODO: The directory of your Nextcloud installation (this is a directory under your web root)
-nextcloudFileDir="/var/www/nextcloud"
+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"
+nextcloudDataDir='/var/nextcloud_data'
 
 # TODO: The directory of your Nextcloud's local external storage.
 # Uncomment if you use local external storage.
-#nextcloudLocalExternalDataDir="/var/nextcloud_external_data"
+#nextcloudLocalExternalDataDir='/var/nextcloud_external_data'
 
 # TODO: The service name of the web server. Used to start/stop web server (e.g. 'systemctl start <webserverServiceName>')
-webserverServiceName="nginx"
+webserverServiceName='nginx'
+
+# TODO: Your web server user
+webserverUser='www-data'
+
+# TODO: The name of the database system (ome of: mysql, mariadb, postgresql)
+databaseSystem='mariadb'
 
 # TODO: Your Nextcloud database name
-nextcloudDatabase="nextcloud_db"
+nextcloudDatabase='nextcloud_db'
 
 # TODO: Your Nextcloud database user
-dbUser="nextcloud_db_user"
+dbUser='nextcloud_db_user'
 
 # TODO: The password of the Nextcloud database user
-dbPassword="mYpAsSw0rd"
-
-# TODO: Your web server user
-webserverUser="www-data"
+dbPassword='mYpAsSw0rd'
 
 # TODO: The maximum number of backups to keep (when set to 0, all backups are kept)
 maxNrOfBackups=0
 
 # File names for backup files
 # If you prefer other file names, you'll also have to change the NextcloudRestore.sh script.
-fileNameBackupFileDir="nextcloud-filedir.tar.gz"
-fileNameBackupDataDir="nextcloud-datadir.tar.gz"
+fileNameBackupFileDir='nextcloud-filedir.tar.gz'
+fileNameBackupDataDir='nextcloud-datadir.tar.gz'
 
 # TOOD: Uncomment if you use local external storage
-#fileNameBackupExternalDataDir="nextcloud-external-datadir.tar.gz"
+#fileNameBackupExternalDataDir='nextcloud-external-datadir.tar.gz'
 
-fileNameBackupDb="nextcloud-db.sql"
+fileNameBackupDb='nextcloud-db.sql'
 
 # Function for error messages
 errorecho() { cat <<< "$@" 1>&2; }
@@ -158,14 +164,31 @@ echo
 #
 # Backup DB
 #
-echo "Backup Nextcloud database..."
-# MySQL/MariaDB:
-mysqldump --single-transaction -h localhost -u "${dbUser}" -p"${dbPassword}" "${nextcloudDatabase}" > "${backupdir}/${fileNameBackupDb}"
+if [ "${databaseSystem,,}" = "mysql" ] || [ "${databaseSystem,,}" = "mariadb" ]; then
+  	echo "Backup Nextcloud database (MySQL/MariaDB)..."
 
-# 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
+	if ! [ -x "$(command -v mysqldump)" ]; then
+		errorecho "ERROR: MySQL/MariaDB not installed (command mysqldump not found)."
+		errorecho "ERROR: No backup of database possible!"
+	else
+		mysqldump --single-transaction -h localhost -u "${dbUser}" -p"${dbPassword}" "${nextcloudDatabase}" > "${backupdir}/${fileNameBackupDb}"
+	fi
+
+	echo "Done"
+	echo
+elif [ "${databaseSystem,,}" = "postgresql" ]; then
+	echo "Backup Nextcloud database (PostgreSQL)..."
+
+	if ! [ -x "$(command -v pg_dump)" ]; then
+		errorecho "ERROR:PostgreSQL not installed (command pg_dump not found)."
+		errorecho "ERROR: No backup of database possible!"
+	else
+		PGPASSWORD="${dbPassword}" pg_dump "${nextcloudDatabase}" -h localhost -U "${dbUser}" -f "${backupdir}/${fileNameBackupDb}"
+	fi
+	
+	echo "Done"
+	echo
+fi
 
 #
 # Start web server