skills.rest
loki495
loki495COMMUNITY
Explore all skills by this author →
GitHub

backup-setup

Backs up site git repositories and MySQL databases to a dedicated backups machine over SSH.

Updated Aug 25, 2017
Search Tags:#automation#git#backup#MySQL#SSH#server administration#database dump
One-click install
npx skills add https://github.com/loki495/dotfiles --skill backup-setup-loki495
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backup-setup
Source: https://github.com/loki495/dotfiles/tree/main/ai/skills/backup-setup
Command: npx skills add https://github.com/loki495/dotfiles --skill backup-setup-loki495

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Setting up recurring backups for a live website involves coordinating SSH keys, database credentials, and git pulls across two servers, and mistakes like reusing the wrong key or missing an auto-created commit on the live site are easy to make. This Skill provides the exact workflow for wiring a new site into an existing backup infrastructure without breaking conventions or other sites. ## Core Features & Use Cases - New site onboarding: Surveys existing backup.conf conventions, generates dedicated SSH keypairs, and creates the site folder and config on the backups machine. - First-run verification: Runs mysqlbk and pull manually and checks table counts and git HEAD against the live server before trusting the setup. - Ongoing orchestration: Uses full-backup with --process-subfolders to sweep many sites at once, and check-backup for read-only status. - Use Case: You inherit a new OpenCart client site and need nightly backups. Follow the workflow to reuse or create the right SSH key, write a backup.conf matching existing patterns, and verify the first dump and git pull succeed. ## Quick Start Set up backups for the new client site by surveying existing backup.conf files on the backups machine and creating a matching config with verified first mysqlbk and pull runs.

Frequently Asked Questions about backup-setup

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

FAQPage Schema
How do I set up backups for a new website on a backup server?▼

Survey existing backup.conf files on the backups machine to match conventions, create a dedicated SSH keypair, write the site's backup.conf with real DB credentials from its live config, then run mysqlbk and pull manually to verify output before scheduling.

How to back up a MySQL database and git repo over SSH?▼

Run mysqlbk from the site's backup folder to dump the database, and pull to mirror the git repo, both executed over SSH against the live server. The full-backup script combines both plus folder syncing and change checks in one call.

Does running a git-based backup modify the live website?▼

Yes, the pull script auto-commits any uncommitted changes on the live site with a generic message before pulling. Commit in-progress work yourself first if you want descriptive messages, and re-fetch any other clones afterward.

Should I reuse one SSH key for backing up multiple sites?▼

Only reuse the shared fleet key for sites on the same AWS EC2 fleet. For unrelated servers, generate a dedicated ed25519 keypair on the backups machine and add its public key to that site's own authorized_keys.

How do I check backup status without running a backup?▼

Use check-backup, which is read-only and reports the current branch, whether it is behind, and the most recent dump date. It backs nothing up and is safe to run anytime.

Related Skills

Explore More Software Engineering Skills→
iamandrewpetersiamandrewpeters
2

ssh-connect

Connect to remote servers via SSH aliases and copy files with SCP.

Community
Basic
michaelnabil230michaelnabil230
3

laravel-backup

Configure Laravel application backups with spatie/laravel-backup, scheduling, retention, monitoring, and alerts.

Community
Intermediate
posit-devposit-dev
4.2k

create-pr

Creates a GitHub pull request for the current session's changes via the GitHub MCP server.

Official
Intermediate
k2worksk2works

operating-backup

Back up and restore AWS RDS and PostgreSQL databases via snapshots and pg_dump.

Community
Intermediate