Aug 18 2011
mysql backup script
#!/bin/bash # Author: Karsten Brusch # change to fit you needs USER=mysql PASS=mypass BACKUPDIR=/nfs/mysql/ BACKUPS LOGFILE=/nfs/mysql/daily-backup.log #no changes needed below DATE=`date +%F_%H-%M-%S` FILENAME=mysqldump.$DATE.sql echo "##########################################" >> $LOGFILE echo "Starting DB backup on `hostname` on `date +%F` `date +%T`" >> $LOGFILE /opt/postman/mysql/bin/mysqldump -u$USER -p$PASS –all-databases 2>> $LOGFILE | gzip > $BACKUPDIR/$FILENAME.gz if [ ${PIPESTATUS[0]} -eq 0 [...]
Comments Off
