Database Backup Restore

Covers the essentials of database backup and restore workflows, from pg_dump and mysqldump commands to point-in-time recovery and cross-region replication. You'll use this when setting up automated backup jobs, defining retention policies, or testing disaster recovery procedures. The reference guides walk through full backups, incremental strategies, and binary log handling for both PostgreSQL and MySQL. The quick start examples are straightforward, showing text and compressed formats plus table exclusions. It's practical for compliance requirements and RTO/RPO planning, though you'll want to adapt the patterns to your specific infrastructure and recovery objectives.

Install to Claude Code

npx -y skills add aj-geddes/useful-ai-prompts --skill database-backup-restore --agent claude-code