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 | 3283 |
| visits | 1273 |
| orders | 1273 |
| order_items | 507 |
| payments | 1443 |
| customer_totals | 6574 |
| daily_customer_totals | 572 |
| customer_payment_transactions | 3013 |
| customer_reports | 11175 |
| visit_signatures | 165 |
| visit_activity_log | 1551 |
| setmore_appointments | 335 |
| backend_no_show_log | 133 |
| square_customer_log | 293 |
| backend_job_runs | 67 |
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 |