Backup a drupal site - both database and site files through cron

I wrote a little linux bash script that I get cron to run each night to create a backup of my drupal site. I may expand it later to include auto deletion of older files and database dumps, but for the meantime I will just manage the backup files manually.

Basically create a file and call it something like site_backup.sh

#!/bin/bash

# Shell script to backup Drupal MySql database and files

# -------------------------------------------------------------------------

# @file

# Backup Drupal MySql database and live site files

#

# @author Gareth Alexander 

# -------------------------------------------------------------------------



Client="myClient"   # CLIENTNAME

MyDBUser="myClientUser"     # USERNAME

MyDBPass="myClientPass"     # PASSWORD

MyDBHost="localhost"     # Hostname

MyDB="myClientDb"       # Database name



# Linux bin paths, change this if it can't be autodetected via which command

MYSQL="$(which mysql)"

MYSQLDUMP="$(which mysqldump)"

TAR="$(which tar)"

CHOWN="$(which chown)"

CHMOD="$(which chmod)"

GZIP="$(which gzip)"





# Backup Dest directory, change this if you have some other location

DBBACKUPDIR=/data/home/$Client/db_dumps

FILEBACKUPDIR=/data/home/$Client/backups



# Backup Dest directory, change this if you have someother location

LIVEDIR=/data/home/$Client/live/public_html



# Get data in ddmmyyyy-hhmm format

NOW="$(date +"%d%m%Y-%H%M")"



# Files to store backup archive files

DBFILE=$MyDB-$NOW-db.sql

BACKUPFILE=$Client-$NOW-dir.tar.gz



# Check for backup directories and create them if they don't exist

if [ ! -d "$DBBACKUPDIR" ] ; then # db_dumps dir does not exist so create it

  mkdir ${DBBACKUPDIR}

fi

if [ ! -d "$FILEBACKUPDIR" ] ; then # backups dir does not exist so create it

  mkdir ${FILEBACKUPDIR}

fi



$MYSQLDUMP --host=$MyDBHost --user $MyDBUser --password=$MyDBPass --opt $MyDB > $DBBACKUPDIR/$DBFILE

$TAR -cvzpf $FILEBACKUPDIR/$BACKUPFILE $LIVEDIR  # c -create, v - verbose, -p restore the files to their original modes, f - use the filename arguement, z - gzip