mysqldump.sh

#! /bin/bash

# make sure /etc/mysql.passwd is chmod go-wrx.
# and chmod root:root.
PASSWORD=`cat /etc/mysql.passwd`
NICE='/usr/bin/nice -n 20'
CWD=`/bin/pwd`
UMASK=`umask`
MYSQLDUMP="/usr/bin/mysqldump -u root --password='${PASSWORD}'"
DUMPFILE="/var/backups/mysql.sql"

umask u=r,go-wrx
$NICE $MYSQLDUMP --all-databases > ${DUMPFILE}
umask $UMASK