database-backup-restore
Implement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore procedures, or setting up automated backups.
By aj-geddes · 558 installs
npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore
Source repository · Upstream listing
Database Backup & Restore
Table of Contents
[Overview]( overview)
[When to Use]( when to use)
[Quick Start]( quick start)
[Reference Guides]( reference guides)
[Best Practices]( best practices)
Overview
Implement comprehensive backup and disaster recovery strategies. Covers backup types, retention policies, restore testing, and recovery time objectives (RTO/RPO).
When to Use
Backup automation setup
Disaster recovery planning
Recovery testing procedures
Backup retention policies
Point in time recovery (PITR)
Cross region backup replication
Compliance and audit requirements
Quick Start
pg dump Text Format:
Reference Guides
Detailed implementations in the references/ directory:
Guide Contents
[Full Database Backup](references/full database backup.md) Full Database Backup
[Incremental & Differential Backups](references/incremental differential backups.md) Incremental & Differential Backups
[Full Database Backup](references/full database backup 2.md) Full Database Backup
[Binary Log Backups](references/binary log backups.md) Binary Log Backups
[PostgreSQL Restore](references/postgresql restore.md) PostgreSQL Restore
[MySQL Restore](references/mysql restore.md) MySQL Restore
Best Practices
✅ DO
Follow established patterns and conventions
Write clean, maintainable code
Add appropriate documentation
Test thoroughly before deploying
❌ DON'T
Skip testing or validation
Ignore error handling
Hard code configuration values