#!/bin/bash # Created by Bryan Le Gear - Skynet 2005/10/12 # # This script must be run by dbadmin # and this user must have the root password # configured in ~/.my.cnf # <br> COMPRESS=gzip MYSQLDUMP=mysqldump MYSQLDUMP_ARGS=“-u root -p –lock-tables=false –all-databases” CURRDATE=`date +%d-%m-%Y` BACKUPDIR=/home/backup OUTFILE=$BACKUPDIR/mysqlbackup_$CURRDATE.sql.gz

echo echo “Backing up to: ” $OUTFILE echo “Compressing using: ” $COMPRESS $MYSQLDUMP $MYSQLDUMP_ARGS | $COMPRESS > $OUTFILE

echo “Chmoding to: 400” chmod 400 $OUTFILE