Back Up the Database Every Night: Code Review Practice

We don't have database backups yet. This adds a script that dumps the app database, compresses it, and keeps a week of copies in /var/backups/app, plus a cron entry that runs it at midnight. I ran it by hand on staging and the file showed up with today's date.

Ascripts/backup.sh1 of 2

Files Changed

scripts/

deploy/

scripts/backup.sh

Shell · Click a line number to comment · Tap a line to comment

@@ -0,0 +1,20 @@

#!/bin/bash

# Nightly backup of the app database to /var/backups/app.

BACKUP_DIR=/var/backups/app

DB_NAME=app

DB_USER=backup

DB_PASS=Tr0ub4dor-backup-7

STAMP=$(date +%Y-%m-%d)

FILE=$BACKUP_DIR/$DB_NAME-$STAMP.sql.gz

mkdir -p $BACKUP_DIR

mysqldump --user=$DB_USER --password=$DB_PASS \

--databases $DB_NAME \

| gzip > $FILE

# Keep a week of backups.

find $BACKUP_DIR -name "*.sql.gz" -mtime +7 -delete

echo "Backup finished: $FILE"

Back Up the Database Every Night

scripts/backup.sh

deploy/crontab