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 | 3424 |
| visits | 1509 |
| orders | 1506 |
| order_items | 790 |
| payments | 1735 |
| customer_totals | 6815 |
| daily_customer_totals | 613 |
| customer_payment_transactions | 4532 |
| customer_reports | 11583 |
| visit_signatures | 348 |
| visit_activity_log | 5441 |
| setmore_appointments | 751 |
| backend_no_show_log | 149 |
| square_customer_log | 384 |
| backend_job_runs | 177 |
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 |