#!/bin/sh

# set up all the mysqldump variables
FILE=backup.sql.`date +"%Y%m%d"`
DBSERVER=127.0.0.1
DATABASE=XXX
USER=XXX
PASS=XXX

# command to do mysql database backup (dump)
mysqldump --user=${USER} --password=${PASS} ${DATABASE} > /opt/backups/database/${FILE}

#cron settings, edit the cron tab
# $> crontab -e
# append record
# 0 10 * * * ~/backup.sh
# 10 0 clock daily