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 -- '{}' \; |