← Back to Operations Hub
Operations Hub · Restore Test Results

Phase 1.5 Restore-Test Results

Actual results from the isolated SQLite restore proof run against the Phase 1 backup set. This is the evidence that the backup works — not just a plan that it should.

Run date
April 22, 2026
Verdict
PASS WITH WARNINGS
Counts reconciled
10 / 10
Sample checks
5 / 5
Suppression
PASS
Purchase continuity
PASS
⚠️

PASS WITH WARNINGS

All 10 row counts reconciled. All 5 sample records matched. Suppression and unsubscribe data survived the restore. Purchase continuity confirmed. One warning: this restore used an isolated local SQLite database, not a temp Supabase/PostgreSQL environment. File recoverability and data integrity are proven. A Postgres-native restore test would fully close the loop before any irreversible cutover.

Restore environment

Row-count reconciliation

DatasetExpectedRestoredResult
AC contacts25,93525,935PASS
AC tags112112PASS
AC unsubscribes8181PASS
Supabase contacts195195PASS
Supabase purchases195195PASS
Supabase email suppressions11PASS
Supabase leads198198PASS
Stripe customers4,6394,639PASS
Stripe payments33,35833,358PASS
PayPal transactions5,9645,964PASS
Manifest correction: During the restore proof, row counts for Stripe payments and ActiveCampaign field_values were corrected. The original manifest used a plain line count (wc -l) which can overstate totals when CSV fields contain embedded newlines. The correct counts use the CSV parser. Manifests have been updated.

Sample-record checks

✅

AC contact — sample 1

003kemi@gmail.com · Kemi Opanubi · created 2022-06-12

✅

AC contact — sample 2

007angiekay@gmail.com · Angie Kay · created 2025-05-24

✅

Supabase contact

sandyzim180@proton.me · Sandy Zimmerman · JD-VREV95

✅

Supabase purchase

JD-VREV95 · Modern Dating Sucks - Presale · $25.00

✅

AC unsubscribe

lkeeling830@gmail.com · status=2 · 2026-04-07

Suppression verification

✅

AC unsubscribe survived

lkeeling830@gmail.com · status=2 · unsubscribe date preserved

✅

Supabase suppression survived

test@example.com · source=test · reason=unsubscribed · suppressed_at preserved

Purchase continuity

✅

Contact → Purchase link confirmed

sandyzim180@proton.me (JD-VREV95) → Modern Dating Sucks - Presale · $25.00 · 2026-04-21

Issues found

Recommendation

Safe to proceed to migration planning.

The backup data is real, readable, and recoverable. All counts reconcile. All sample records match. Suppression state survives. Purchase history is traceable.

One remaining step to fully close the loop before any irreversible cutover:

That is a confirmation step, not a blocker. The data is proven safe.