#!/bin/bash

#Main settings
DOMAIN_DIR="/path/to/your/public_html"
BACKUP_DIR="/path/to/your/backup"
DATE=$(date +%Y-%m-%d)

# MySQL Settings
DB_HOST="localhost"
DB_USER="mysql_username"
DB_PASS="mysql_username_password"
DB_NAME="mysql_database"

[ ! -d "$BACKUP_DIR" ]  && mkdir -p $BACKUP_DIR

# MySQL Backup
mysqldump -u $DB_USER --password=$DB_PASS --opt --databases $DB_NAME | gzip -9 >${BACKUP_DIR}/${DATE}_backup.sql.gz

#Files Backup
tar cfzP - $DOMAIN_DIR >${BACKUP_DIR}/${DATE}_backup.tar.gz