Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # MySQL backup script
- # Last update: 20090504
- #
- MHOST=localhost
- MUSER=backup
- MPASS=OwBPimRc
- BACKUPDIR="/mnt/backup"
- ########################################################################
- MYSQL="$(which mysql)"
- MYSQLDUMP="$(which mysqldump)"
- GZIP="$(which gzip)"
- DBPREFIX="$(hostname -s).mysqldb"
- echo "Run MySQL backup"
- DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
- for db in $DBS
- do
- FILE=${BACKUPDIR}/${DBPREFIX}.${db}.gz
- $MYSQLDUMP --no-tablespaces --skip-lock-tables -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
- done
- MHOST=localhost
- MUSER=backup
- MPASS=OwBPimRc
- BACKUPDIR="/mnt/backup"
- MYSQL="$(which mysql)"
- MYSQLDUMP="$(which mysqldump)"
- GZIP="$(which gzip)"
- DBPREFIX="$(hostname -s).mysqldb"
- echo "Run MySQL backup"
- DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
- for db in $DBS
- do
- FILE=${BACKUPDIR}/${DBPREFIX}.${db}.`date +%Y%m%d`.gz
- $MYSQLDUMP --no-tablespaces --skip-lock-tables -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
- done
- find -name "${BACKUPDIR}/${DBPREFIX}*" -type f -mtime +10 -exec rm -f '{}' ';'
- /mnt/backup/*.mysqldb {
- daily
- rotate 10
- missingok
- nocompress
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement