gistfile1.sh

#!/bin/bash
DBPATH=/home/hybrid/mysql_backups
MYSQLDMP=/opt/local/bin/mysqldump
FIND=/opt/local/bin/find
DATE=`date "+%Y-%m-%d"`

$MYSQLDMP --opt --skip-add-locks --user=hybrid_dbuser --password= xxxxxx --default-character-set=utf8 hybrid_forumdb | gzip > ${DBPATH}/hybrid_forumdb-${DATE}.gz
chown hybrid:hybrid ${DBPATH}/hybrid_forumdb-${DATE}.gz

# Deletes old backups
for DIR in `ls -1 $DBPATH`
do
    $FIND ${DBPATH}/${DIR}/*.gz -mtime +14 -delete
done