SHOW:
|
|
- or go back to the newest paste.
| 1 | #!/bin/bash | |
| 2 | # NANO Tip Bot Database backup | |
| 3 | # Easiest way to start backing up your database, update backup_folder and database_path and stick it in /etc/cron.hourly or daily, etc. | |
| 4 | ||
| 5 | ### CHANGE THESE | |
| 6 | - | backup_folder="/path/to/store/backups" |
| 6 | + | backup_folder="/home/tipbot/nanobot_backup" |
| 7 | database_path="/home/tipbot/nanobot/nanotipbot.db" | |
| 8 | ### CHANGE THESE | |
| 9 | ||
| 10 | # Don't change me | |
| 11 | backup_file="${backup_folder}/$(date +%Y-%m-%d_%H_%M_%S).bak"
| |
| 12 | sqlite3 $database_path .dump > $backup_file | |
| 13 | zip -m "${backup_file}.zip" $backup_file
| |
| 14 | # Delete backups older than 7 days | |
| 15 | find $backup_folder -type f -mtime +7 -name '*.zip' -execdir rm -- '{}' \; |
