Most providers offer backups of the entire web space (database and files) as standard. The problem is that there is usually no guarantee for this (usually to be found in the provider's general terms and conditions). This means that in the worst case you may be left without a website or have to hope to find an old copy somewhere.

These are the advantages of our backup programme

• additional security through your own copy and therefore independent of the provider
• different backup intervals and strategies can be configured
• easy manual execution possible (if it has to be done quickly)
• easy mirroring of data to other servers
• Simple and fast restoring possible
• no licensing costs, the software is published under the "freeware" licence conditions GPL v2.0

#!/bin/bash

# Copyright 2021 Oliver Wassenaar (WACON Internet GmbH)

# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.

# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more  details: <http://www.gnu.org/licenses/>.

# get command line parameter
for arg in "$@"
do
    case $arg in
        -d|--database)
        DB_ONLY=1
        shift
        ;;
        -n|--nomail)
        NO_MAIL=1
        shift
        shift
        ;;
    esac
done

# config parameter 
sitename=wacon
targetdir=<TARGETDIR>/backup
projectdir=<WEB_ROOTPATH>
backupfile=$sitename$(date +"%Y%m%d")_$$
dbfile=db.sql_$$
logfile=$targetdir/log/log_$$
errorlog=$targetdir/log/error_$$
mailtext=$targetdir/mailtxt_$$

# db credentials
dbname=<DB_NAME>
host=<DB_HOST>
user=<DB_USER>
password=<DB_PASSWORD>


# password of backup file 
zippw=<MYPASSWD>

# comma separated list of mail receiver
mailreceiver="<TO_ADDRESS1>, <TO_ADDRESS2>, ..."
mailsender="<SENDER_ADDRESS>"

# delete all log files older than 30 days
find $targetdir/log -maxdepth 1 -type f -name '*' -mtime +30 -exec rm {} \;

exec 1>>$logfile 2>>$errorlog

echo "Begin backup: $(date +%F_%T)"

# delete all db backups older than 7 days (e.g. to run the db backup every day)
find $targetdir/archive/db -maxdepth 1 -type f -name '*' -mtime +7 -exec rm {} \;

# database dump
mysqldump --opt --no-tablespaces -h$host -u$user -p$password $dbname -r $targetdir/$dbfile

cd $targetdir
tar cvf $backupfile $dbfile 

if ! [[ -n "$DB_ONLY" ]]
then
	# delete all files older than 90 days(in this case you shouldn't run the complete backup too frequently, e.g. once a month)
	find $targetdir/archive/all -maxdepth 1 -type f -name '*' -mtime +90 -exec rm {} \;
	cd $projectdir
	# files of rootpath(e.g. htaccess, favicon, etc.) 
	find . -maxdepth 1 -type f -print0 | xargs -0 tar rf $targetdir/$backupfile

	# important directories (uploads possibly not necessary)
	find fileadmin -type f -print0 | xargs -0 tar rvf $targetdir/$backupfile
	find typo3conf -type f -print0 | xargs -0 tar rvf $targetdir/$backupfile
	find uploads -type f -print0 | xargs -0 tar rvf $targetdir/$backupfile
fi

backupsize=$(du -h $targetdir/$backupfile | awk '{print $1}')
dbsize=$(du -h $targetdir/$dbfile | awk '{print $1}')

# compress files
cd $targetdir
zip -P $zippw $backupfile.zip $backupfile

if ! [[ -n "$DB_ONLY" ]]
then
	backupscope="database and files"
	# move to archive
	mv $backupfile.zip $targetdir/archive/all/
else
        backupscope="database ONLY"
        mv $backupfile.zip $targetdir/archive/db/
fi


#clean up
rm $backupfile
rm $dbfile 


if ! [[ -n "$NO_MAIL" ]]
then
	echo "backup scope: $backupscope" > $mailtext
	errno=$(wc -l $errorlog |  awk '{print $1}')
	echo "number of errors in errorlog: $errno (see below)" >> $mailtext
	echo "size of database dump: $dbsize" >> $mailtext
	echo "complete size of backup: $backupsize"  >> $mailtext
	echo "end of backup process: $(date +%F_%T)"  >> $mailtext
	echo "---------------------------------------------------------------------"  >> $mailtext

	cat $errorlog >> $mailtext

	cat $mailtext | mail -s "Backup: $sitename" $mailreceiver -r$mailsender 

	rm $mailtext
fi