Database Backup Restore

aj-geddes/useful-ai-prompts/skills/database-backup-restore

作者 aj-geddes3f5182cfd739無授權條款355 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫7 個月前更新

Implement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore procedures, or setting up automated backups.

包含腳本DevOps & Cloud

AI 產生的概覽

指導資料庫備份與還原策略，涵蓋 PostgreSQL 和 MySQL 的全量、增量及二進位日誌備份。

功能: 此技能提供實作資料庫備份與災難復原策略的參考指南，涵蓋全量、增量、差異及二進位日誌備份、保留策略、還原測試和復原目標（RTO/RPO），並包含 PostgreSQL 和 MySQL 的專用還原指南。它亦附帶一個結構驗證指令碼和一個遷移 SQL 範本。
適用情境: 適用於設定備份自動化、規劃災難復原、測試還原程序、制定保留策略，或準備時間點復原與合規稽核要求的場景。
執行需求: 需要資料庫工具（例如 pg_dump 和 MySQL 工具）以及對目標資料庫伺服器的存取憑證。附帶可執行 shell 指令碼（scripts/validate-schema.sh）和一個 SQL 遷移範本。

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:

bash

# Simple full backuppg_dump -h localhost -U postgres -F p database_name > backup.sql
# With compressionpg_dump -h localhost -U postgres -F p database_name | gzip > backup.sql.gz
# Backup with verbose outputpg_dump -h localhost -U postgres -F p -v database_name > backup.sql 2>&1
# Exclude specific tablespg_dump -h localhost -U postgres database_name \  --exclude-table=temp_* --exclude-table=logs > backup.sql

# Simple full backuppg_dump -h localhost -U postgres -F p database_name > backup.sql
# With compressionpg_dump -h localhost -U postgres -F p database_name | gzip > backup.sql.gz
# Backup with verbose outputpg_dump -h localhost -U postgres -F p -v database_name > backup.sql 2>&1
# Exclude specific tablespg_dump -h localhost -U postgres database_name \  --exclude-table=temp_* --exclude-table=logs > backup.sql

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
Full Database Backup [blocked]	Full Database Backup
Incremental & Differential Backups [blocked]	Incremental & Differential Backups
Full Database Backup [blocked]	Full Database Backup
Binary Log Backups [blocked]	Binary Log Backups
PostgreSQL Restore [blocked]	PostgreSQL Restore
MySQL Restore [blocked]	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

來源與署名

來源：aj-geddes/useful-ai-prompts位於skills/database-backup-restore提交3f5182c

授權條款：無授權條款

內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。

檢舉或申請下架

更多來自 aj-geddes/useful-ai-prompts 的技能

Xss Prevention

aj-geddes

Prevent Cross-Site Scripting (XSS) attacks through input sanitization, output encoding, and Content Security Policy. Use when handling user-generated content in web applications.

待分類3557 個月前更新

Wireframe Prototyping

aj-geddes

Create wireframes and interactive prototypes to visualize user interfaces and gather feedback early. Use tools and techniques to communicate design ideas before development.

待分類3557 個月前更新

Web Performance Optimization

aj-geddes

透過程式碼分割、延遲載入、快取、壓縮與監控來指導 Web 效能最佳化。

Software Development3557 個月前更新

Vue Application Structure

aj-geddes

指導使用組合式 API、元件組織與 TypeScript 來建構 Vue 3 應用程式結構。

Software Development3557 個月前更新

Visual Regression Testing

aj-geddes

透過跨版本比較截圖來偵測 UI 中非預期的視覺變化，指導視覺回歸測試。

Software Development3557 個月前更新

User Persona Creation

aj-geddes

依據研究建立詳細的使用者人物誌，用來指引產品設計、優先順序與訊息溝通。

Research & Analysis3557 個月前更新

Database Backup Restore

Database Backup & Restore

Table of Contents

Overview

When to Use

Quick Start

Reference Guides

Best Practices

✅ DO

❌ DON'T

來源與署名

更多來自 aj-geddes/useful-ai-prompts 的技能

Xss Prevention

Wireframe Prototyping

Web Performance Optimization

Vue Application Structure

Visual Regression Testing

User Persona Creation

更多DevOps & Cloud技能

Playwright Devops

M5 Onboard

Yeet

Runbook

Incident Response

Deploy Checklist