Backup mysql database script

From Wiki

Jump to: navigation, search
# 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

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
Personal tools