Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- rm -f /backup/mysql*
- ### System Setup ###
- BACKUP=/backup
- NOW=$(date +"%Y-%m-%d")
- ### MySQL Setup ###
- MUSER="mysqluser"
- MPASS="password"
- MHOST="localhost"
- MYSQL="$(which mysql)"
- MYSQLDUMP="$(which mysqldump)"
- GZIP="$(which gzip)"
- ### Start MySQL Backup ###
- # Get all databases name
- DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
- for db in $DBS
- do
- FILE=$BACKUP/mysql-$db.$NOW-$(date +"%T").gz
- $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
- done
Add Comment
Please, Sign In to add comment