backup shellscript.

backup.sh

#!/bin/sh

# variables
name="username"
dbpass="dbpass"
dbname="dbname"
host="host"
dirname="dirname"

# dump
/usr/local/bin/mysqldump --host $host -u $name --password=$dbpass --hex-blob --opt --disable-keys --quote-names $dbname > /home/$username/backups/$dbname-`date +%Y%m%d`.dump

# backup files
today=`date +%d`
even=`expr $today % 10`

if test $even -eq 1 ; then
	tar czvfp /home/$username/backups/$dbname-`date +%Y%m%d`.tar.gz /home/$name/$dirname/
fi

# garbage collector
find /home/$username/backups/ -type f -ctime +31 -exec rm -f {} \;

# Memo:
# mkdir ~/backups
# crontab -e
# 0 4 * * * sh backup.sh

exit