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