mysql backup script

#!/bin/bash
# Blog Data Daily Backup Script
# 050531 Jeffrey Script Created
# 050705 Jeffrey Variables of info included
# 050818 Jeffrey One More Options --compatible=mysql40 added
if [ -z "$1" ] || [ -z "$2" ]; then
echo "usage: sh $0 backupmysqldb mailto"
exit
fi


/bin/sync
/bin/mkdir /tmp/wpbackup
chmod 700 /tmp/wpbackup
cd /tmp/wpbackup
/usr/bin/mysqldump -uroot -ppassword --compatible=mysql40 --opt $1 > /tmp/wpbackup/$1.`date +%y%m%d`.sql
/usr/bin/mutt -s /tmp/wpbackup/$1.`date +%y%m%d`.sql -a /tmp/wpbackup/$1.`date +%y%m%d`.sql $2 < $0
rm -rf /tmp/wpbackup

Comments

Popular Posts