Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- ## configuration {
- BACKUP_DIR="ABSOLUTE_PATH_TO_BACKUP_DIR"
- DBNAME="UR_DB_NAME"
- DBUSER="UR_DB_USER"
- DBPASSWD="UR_DB_PASSWORD"
- DATE_TEMPLATE="$(date '+%Y.%m.%d %H-%M')"
- DAYS_TO_STORE=30
- ## }
- fname="${BACKUP_DIR}/${DBNAME}_${DATE_TEMPLATE}.sql"
- # ensure existence of $BACKUP_DIR
- mkdir -p "${BACKUP_DIR}"
- mysqldump --routines --user="${DBUSER}" --password="${DBPASSWD}" "${DBNAME}" > "${fname}"
- nice -n 20 gzip --best "${fname}"
- # delete old backups
- find "${BACKUP_DIR}" -type f -name "*.gz" -ctime "+${DAYS_TO_STORE}" -delete
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement