[ADMIN] How to back up the production database

  1. Hosting panel (Namecheap cPanel) → Backup → Download a Full MySQL Database Backup.
  2. Save to SJ Master Backup/DB-Snapshots/{date}-prod.sql.gz.
  3. Verify file size is reasonable (not 0 bytes, not absurdly small).
  4. For a quick logical backup via WP-CLI: wp db export prod-{date}.sql --add-drop-table.
  5. 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.

[ADMIN] How to safely delete a deactivated tenant

Run only after the 30-day grace period and at least one final email to the customer.

  1. Confirm deletion date in wpp3_sj_crm_tenants.
  2. Export the subsite’s data as one final backup: Network Admin → Sites → Edit → Tools → Export, OR run wp export via WP-CLI.
  3. Save the export to SJ Master Backup/Tenant-Final-Exports/{slug}-{date}.xml.
  4. Network Admin → Sites → Delete (this drops all wpp3_{blog_id}_* tables).
  5. Update wpp3_sj_crm_tenants row status to deleted with timestamp.
  6. Log in SJ Journal.

Backups are kept for 60 days then purged per privacy policy.