Simple script which can be easily modified if needed for backup rotation. This script use ssh and rsync for syncing This script is completely rewriten , old script can be found here : https://github.com/todiadiyatmo/bash-backup-rotation-script/tree/legacy-1.0.0 .
- Daily, Weekly, Monthly backup script with number of retention (backup to keep) option
- backup to local only, local + remote and remote only mode
- 4 different backup script :
- file backup with zip compression script
- rsync script
- mysql script
- mysql with extrabackup script
- Secure backup with SSH connection
This release is still missing this feature from the old relesae
- email notification
- Copy script to desired location
- Edit the parameter of the script, configure the
BACKUP_RETENTION_to set the rotation / number of backup needed
### User Pass Mysql ###
USER=backup
PASS=backup
DBNAME=project_sql
BACKUP_DIR="/root/backup"
DST_HOST="user@host"
REMOTE_DST_DIR="/root/backup"
BACKUP_DAILY=true # if set to false backup will not work
BACKUP_WEEKLY=true # if set to false backup will not work
BACKUP_MONTHLY=true # if set to false backup will not work
BACKUP_RETENTION_DAILY=3
BACKUP_RETENTION_WEEKLY=3
BACKUP_RETENTION_MONTHLY=3
- test the script to make sure everything correct , ex :
mysql-backup-script.sh - put script on cron to make sure it is running everyday at your desired time :
00 03 * * * backup.sh - check your backup result
- profit :)
feel free to open pull request and submit bug ticket