backup

Back up and restore MySQL databases with Cloudflare R2 archival.

Updated Mar 7, 2026
One-click install
npx skills add https://github.com/billyfranklim1/claude-skills --skill backup-billyfranklim1
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: backup
Source: https://github.com/billyfranklim1/claude-skills/tree/main/plugins/backup/skills/backup
Command: npx skills add https://github.com/billyfranklim1/claude-skills --skill backup-billyfranklim1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Prevents data loss and reduces downtime by providing clear procedures and tooling for creating, storing, and restoring MySQL database backups, including automated scheduling and retention policies.

Core Features & Use Cases

  • Automated scheduled backups: Daily cron-driven mysqldump executed by a configured script to produce consistent database snapshots.
  • Cloud archival to Cloudflare R2: Uploads backups to a Cloudflare R2 bucket (mybackup/backups/databases/) for off-host retention and retrieval.
  • Manual restore and verification: Instructions and commands for downloading, decompressing, and restoring specific backups while enforcing safety checks such as confirming with the owner and backing up the current state first.
  • Auditing and logs: Guidance to view backup logs and verify success, and retention enforcement for 30-day lifecycle.

Quick Start

Run the backup script to create an immediate mysqldump of the configured databases and confirm the uploaded file exists in Cloudflare R2 under mybackup/backups/databases/.

Frequently Asked Questions about backup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate scheduled MySQL backups and upload them to Cloudflare R2?

Automated MySQL backups use a daily cron-driven mysqldump script to create snapshots and upload them to a Cloudflare R2 bucket. You need backup scripts and R2 credentials to ensure scheduled execution and off-host archival.

What is the retention policy for MySQL database backups stored in Cloudflare R2?

The backup retention policy enforces a 30-day lifecycle for stored MySQL database snapshots. This lifecycle management applies to off-host backups archived in the Cloudflare R2 bucket under the designated databases directory.

Can I manually restore a MySQL database from a Cloudflare R2 backup?

Yes, manual restores involve downloading and decompressing specific MySQL backups from Cloudflare R2. The restore process enforces safety checks, including confirming with the owner and backing up the current database state first.

How do I verify if a nightly mysqldump executed successfully?

You can verify nightly mysqldump execution by viewing backup logs to check for success. The logging and auditing guidance helps confirm that the backup script ran correctly and the uploaded file exists in Cloudflare R2.

Do I need separate backup configurations for staging and production MySQL environments?

The backup procedures apply to both production and staging MySQL environments. You can execute backup scripts, enforce retention policies, and manage Cloudflare R2 archival across different deployment environments using the same tooling.