#!/bin/bash
#backup database to bzipped file
#usage: mybackup <database> <directory> <backupuser> <backuppass>

BACKFILE=$2/$1_$(date +"%Y%m%d").sql.bz
echo "Backing up drupal database: $1 into file: $BACKFILE"
nice mysqldump -u $3 -p$4 --compress --add-drop-table --extended-insert $1 | bzip2 -9 >$BACKFILE