#!/bin/sh
# script to create backup file and
bkppath=/usr/local/htdocs-archive
bkpdate=`date +%Y-%m-%0e`

# move to and create folder for work
cd $bkppath
mkdir $bkpdate
cd $bkpdate

# grab mysqldump
## mysqldump -q --all-databases | bzip2 -c > /root/backup/mysql/mysql.`date +%Y-%m-%0e`.sql.bz2
#new method requires ~/.my.cnf to have [client] \n pass=XXXXX
/opt/mysql-bkp.csh

# create tarball
tar czf htdocs.$bkpdate.tgz /var/www