The Father, the Son and the Grandfather: A Basic Backup Strategy

GFS-mysql-backup.sh

#!/bin/sh
# Created by:     Alex Saavedra
# Date created:   2011-05-11
# Last modified:  2010-05-11
# Purpose:        ProcessMaker backup.
# Change log:
# Syntax:  
#    backup.sh <periodicity> <period>
# Parameters:
#     <periodicity> = weekly, monthly, yearly
#     <period>      = specific week day, month or year

# Help
HELP="The backup is invoked as follows:\n"
HELP=$HELP"  /root/backup.sh <type> <periodicity>\n"
HELP=$HELP"where:n"
HELP=$HELP"  periodicity = weekly, monthly, yearly\n"
HELP=$HELP"  period      = specific day, month or year\n"

# Destination backup file construct.
DST=/path/to/backups/processmaker_$1_$2.tgz
# Now DST is similar to "/path/to/backups/processmaker_weekly_03.tgz"

# SQL dump file name construct
SQL=/tmp/processmaker_$1_$2.sql

if [ -z "$2" ]
  then
    # In recent distributions you may not need the -e parameter.
    echo -e $HELP
    exit 1
fi

# timestamp logging
echo "Starting date and time: $(date)"

# database dump: wf_workflow, rb_workflow and rp_workflow are ProcessMaker databases.
mysqldump --opt --add-drop-table -B -u root -psecret --result-file=$SQL wf_workflow rb_workflow rp_workflow 
# use the following line if you prefer a backup of all databases:
#mysqldump --opt --add-drop-table --all-databases -u root -psecret --result-file=$SQL 

# Source file construct
SRC=/opt/processmaker/ $SQL

# actual backup
tar -cvzf $DST $SRC > /dev/null

echo "Finished date and time: $(date)"
echo "The backup file $DST was successfully created."
ls -lh $DST

Taken from http://www.processmakerblog.com/backup/the-father-the-son-and-the-grandfather-a-basic-backup-strategy/