Backup Mysql and Delete file 7 days ago

backup-mysql.sh

#!/bin/sh

DATE=`date +%d%b-%H%M%S`

unset PATH
# USER VARIABLES
MYSQLUSER=your-user
MYSQLPWD=your-password
MYSQLHOST=localhost
MYSQLBACKUPDIRROOT=~/backup/mysql
MYSQLBACKUPDIR=$MYSQLBACKUPDIRROOT/$DATE
MYSQLDB=your-database

FILE=$MYSQLBACKUPDIR.tgz; # No need to modify this one

# PATH VARIABLES – It depend on your server program
MK=/bin/mkdir;
RM=/bin/rm;
GREP=/bin/grep;
MYSQL=/usr/bin/mysql;
MYSQLDUMP=/usr/bin/mysqldump;
XARGS=/usr/bin/xargs;
FIND=/usr/bin/find;
TAR=/bin/tar;
UUENCODE=/usr/bin/uuencode;

# CREATE MYSQL BACKUP

# Delete the old ones. The +7 means 7 days ago
$FIND $MYSQLBACKUPDIRROOT/* -mtime +7 | $XARGS $RM -rf

# Create new backup dir
$MK -p $MYSQLBACKUPDIR

#Dump new files
$MYSQLDUMP                                                    \
-u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST                         \
-Q -c -C --add-drop-table --add-locks --quick --skip-lock-tables   \
$MYSQLDB > $MYSQLBACKUPDIR/$MYSQLDB.sql;

# collect and compress the sqls
$TAR -cvzpf $MYSQLBACKUPDIR.tgz -P $MYSQLBACKUPDIR
$RM -r $MYSQLBACKUPDIR