cron daily backup script

backup.sh

#!/bin/bash

export LANG=C

BACKUPDIR=/data/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
MARIADB_DATABASES=$(\
 mysql --defaults-extra-file=${MARIADB_CONF} -s -e 'SHOW DATABASES' | \
 sed -e '/^Database$/d' \
     -e '/^mysql$/d' \
     -e '/^information_schema$/d' \
     -e '/^performance_schema$/d' \
)
if test ! -z "${MARIADB_DATABASES}"; then
  for database in ${MARIADB_DATABASES}; do
    mysqldump --defaults-extra-file=${MARIADB_CONF} -Q --opt --skip-extended-insert ${database} | gzip > $BACKUPDIR/mariadb/${database}.sql.gz
  done
fi

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

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

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

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