cron daily backup script

backup.sh

#!/bin/bash

export LANG=C

BACKUPDIR=/backup/daily
DATE=`date`

if test ! -d $BACKUPDIR; then
  mkdir -p $BACKUPDIR
  chmod 700 $BACKUPDIR
fi

echo $DATE > $BACKUPDIR/timestamp.txt

# mariadb data
MARIADB_CONF=/data/admin/etc/my.cnf
if test ! -d $BACKUPDIR/mariadb; then
  mkdir -p $BACKUPDIR/mariadb
fi
if [ -f "${MARIADB_CONF}" ]; then
  MARIADB_OPTS="--defaults-extra-file=${MARIADB_CONF}"
fi
MARIADB_DATABASES=$(\
  mysql ${MARIADB_OPTS} -s -e 'SHOW DATABASES' | \
  sed -e '/^Database$/d' \
      -e '/^mysql$/d' \
      -e '/^information_schema$/d' \
      -e '/^performance_schema$/d' \
      -e '/^sys$/d' \
)
if test ! -z "${MARIADB_DATABASES}"; then
  for database in ${MARIADB_DATABASES}; do
    mysqldump ${MARIADB_OPTS} -Q --opt --skip-extended-insert ${database} | gzip > $BACKUPDIR/mariadb/${database}.sql.gz
  done
fi

# web data
rsync -aq --delete /data/www $BACKUPDIR/

# root
rsync -aq --delete /root $BACKUPDIR/

# home
rsync -aq --delete /home $BACKUPDIR/

# etc
rsync -aq --delete /etc $BACKUPDIR/

# logs
rsync -aq --delete /var/log $BACKUPDIR/