Database Backups¶
VPS2 — Full Backup¶
# All databases
mysqldump -u redrum -p --all-databases --single-transaction \
> /home/deploy/backups/all_dbs_$(date +%Y%m%d).sql
# Specific database
mysqldump -u redrum -p vehicles_db --single-transaction \
> /home/deploy/backups/vehicles_$(date +%Y%m%d).sql
Schedule¶
| Frequency | What | Retention |
|---|---|---|
| Daily | vehicles_db | 7 days |
| Weekly | All databases | 4 weeks |