mysql backup

backup.sh

#!/bin/sh

DBUSER=ooo
DBPASS=xxx
DBNAME=db

DAYS=7
DEST=/path/your/folder
DATE=`date +%Y%m%d`

mkdir -p $DEST

echo "Remove old over $DAYS SQL files"
find $DEST -name '*.sql' -mtime "+$DAYS" -exec rm {} \;

echo "Backup Databases to SQL file"
mysqldump -u$DBUSER -p$DBPASS $DBNAME > $DEST/$DBNAME-$DATE.sql