[BLOCKER P1] No automated MySQL backup for cPanel WordPress sites #9

New Issue

2026-07-03T10:57:05Z

wmj commented

2026-07-03 10:57:05 +00:00

Context

ummah.falahos.my was restored from a MySQL dump that existed only locally at /root/ummahwp_dump.sql. There is no automated backup pipeline for the cPanel MySQL databases (maiforsc_ummahwp, maiforsc_wp646, etc.).

Risk

If the cPanel server goes down or a migration goes wrong, we have:

✅ One manual SQL dump pushed to falah-os/cpanel-db-backups (after the fact)
❌ No recurring/scheduled backup
❌ No off-site replication

Action Required

Design and implement an automated MySQL dump + push to Gitea (falah-os/cpanel-db-backups) on a daily schedule. Options:

Cron job on Contabo VPS that connects to cPanel MySQL remotely and dumps (blocked by Imunify360)
MacBook Air cron via Playwright that logs into cPanel phpMyAdmin and exports (brittle but works)
WP plugin that dumps DB to Gitea via API on schedule

Tagged

@hermes — to implement the backup pipeline
@ody — to research the best approach given Imunify360 restrictions

Priority

P1 — Without automated backups, we lose all cPanel DB changes between manual snapshots.

## Context ummah.falahos.my was restored from a MySQL dump that existed only locally at `/root/ummahwp_dump.sql`. There is no automated backup pipeline for the cPanel MySQL databases (maiforsc_ummahwp, maiforsc_wp646, etc.). ## Risk If the cPanel server goes down or a migration goes wrong, we have: - ✅ One manual SQL dump pushed to `falah-os/cpanel-db-backups` (after the fact) - ❌ No recurring/scheduled backup - ❌ No off-site replication ## Action Required Design and implement an automated MySQL dump + push to Gitea (`falah-os/cpanel-db-backups`) on a daily schedule. Options: 1. Cron job on Contabo VPS that connects to cPanel MySQL remotely and dumps (blocked by Imunify360) 2. MacBook Air cron via Playwright that logs into cPanel phpMyAdmin and exports (brittle but works) 3. WP plugin that dumps DB to Gitea via API on schedule ## Tagged @hermes — to implement the backup pipeline @ody — to research the best approach given Imunify360 restrictions ## Priority P1 — Without automated backups, we lose all cPanel DB changes between manual snapshots.

wmj self-assigned this 2026-07-03 10:57:05 +00:00

wmj removed their assignment 2026-07-07 12:08:37 +00:00

pi was assigned by wmj

2026-07-07 12:08:38 +00:00

openhand was assigned by wmj

2026-07-07 12:08:38 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: wmj/hermes-cpanel-agent#9