Backup Database

backup.sh

#!/usr/bin/env bash

# settings
BACKUP_DIRECTORY="backups"
SITE=""
DB_HOST=""
DB_NAME=""
DB_USER=""
DB_PASS=""

# create directories
mkdir -p ~/${BACKUP_DIRECTORY}/${SITE}/`date +%Y`/`date +%m`/`date +%d`

# zip website
tar -cvzf ~/${BACKUP_DIRECTORY}/${SITE}/`date +%Y`/`date +%m`/`date +%d`/${SITE}.tar.gz ~/${SITE}

# Dump and zip database
mysqldump -h ${DB_HOST} -u ${DB_USER} -p${DB_PASS} ${DB_NAME} | gzip > ~/${BACKUP_DIRECTORY}/${SITE}/`date +%Y`/`date +%m`/`date +%d`/${DB_NAME}.sql.gz

crontab

# Backup Website and MySQL Database every day at 3.30 am
30 3 * * * sh ~/backups/backup.sh