Operations
Create timestamped snapshots of critical live production tables (operations, payments, totals, ledger, and reporting) in a dedicated backup database before major loads or cleanup.
Create Snapshot
This copies all critical operational/financial tables including payments, customer_payment_transactions, customer_totals, and daily_customer_totals into a separate backup database using timestamped table names.
Live Counts
| Table | Rows |
|---|---|
| customers | 3391 |
| visits | 1455 |
| orders | 1455 |
| order_items | 733 |
| payments | 1706 |
| customer_totals | 6769 |
| daily_customer_totals | 606 |
| customer_payment_transactions | 4507 |
| customer_reports | 11537 |
| visit_signatures | 325 |
| visit_activity_log | 5117 |
| setmore_appointments | 683 |
| backend_no_show_log | 147 |
| square_customer_log | 381 |
| backend_job_runs | 155 |
History
| Created | Target DB | Suffix | Tables | Total Rows | Action |
|---|---|---|---|---|---|
| 2026-04-14 16:45:49 | ellas_alterations_backup | snapshot_20260414_204542 | 15 | 28323 | |
| 2026-04-14 15:16:36 | ellas_alterations_backup | snapshot_20260414_191633 | 5 | 7416 |