#!/bin/bash
# @(#) $Id$

DBNAME=cutedbname
DBHOST=mysql.example.com
DBPASS=noway

BCKDIR=$HOME/backups/mysql
BCKFILE="$DBNAME-`date +%a`.sql"

uptime

[ ! -d $BCKDIR ] && mkdir -p $BCKDIR

echo "`date` : starting backup"

# I don't have RELOAD privs, so can't use
#   --flush-logs
#   --lock-all-tables

mysqldump > $BCKDIR/$BCKFILE    \
    --host=$DBHOST              \
    --opt                       \
    --allow-keywords            \
    --comments                  \
    --create-options            \
    --disable-keys              \
    --password=$DBPASS          \
    $DBNAME

echo "`date` : completed"

chmod u=rw,g=,o= $BCKDIR/$BCKFILE
ls -lh $BCKDIR/$BCKFILE

uptime

# end