- Hosting panel (Namecheap cPanel) → Backup → Download a Full MySQL Database Backup.
- Save to
SJ Master Backup/DB-Snapshots/{date}-prod.sql.gz.
- Verify file size is reasonable (not 0 bytes, not absurdly small).
- For a quick logical backup via WP-CLI:
wp db export prod-{date}.sql --add-drop-table.
- Daily automated backups also run via the host — keep 30 days of those.
Always run a manual backup before a plugin update or schema change.
Run only after the 30-day grace period and at least one final email to the customer.
- Confirm deletion date in
wpp3_sj_crm_tenants.
- Export the subsite’s data as one final backup: Network Admin → Sites → Edit → Tools → Export, OR run
wp export via WP-CLI.
- Save the export to
SJ Master Backup/Tenant-Final-Exports/{slug}-{date}.xml.
- Network Admin → Sites → Delete (this drops all
wpp3_{blog_id}_* tables).
- Update
wpp3_sj_crm_tenants row status to deleted with timestamp.
- Log in SJ Journal.
Backups are kept for 60 days then purged per privacy policy.