#!/bin/bash

USER='root'
PASS='root'
DATABASE='drupal'

# Create folders if it's not yet.
mkdir -p ~/backups/{database,files}

# Backup.
mysqldump -u$USER -p$PASS $DATABASE | gzip -9 > ~/backups/database/$DATABASE-`date +"%d-%m-%Y"`.sql.gz
tar -czvf ~/backups/files/files-`date +"%d-%m-%Y"`.tar.gz /var/www/html/drupal/sites/default/files

# Delete backups older than 30 days.
find ~/backups/* -mtime +30 -exec rm {} \;