b01cf19db6
scripts/refresh-legacy-report-tables.sh: dumps only the 4 tables the overpriced-internet report needs (account/delivery/service/product) from the live legacy DB with --single-transaction (non-locking), verifies the dump is complete before importing into the local legacy-db copy. ~20MB, seconds. Creds read from a prod-only .refresh.env (gitignored; .env.example committed). Used to refresh the copy from the 2026-05-22 snapshot to current (service 66741→69233, account 15321→15706). Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
9 lines
507 B
Plaintext
9 lines
507 B
Plaintext
# Copier en .refresh.env (à côté du script, sur l'hôte prod) puis remplir.
|
|
# chmod 600 .refresh.env — contient des mots de passe, NE PAS versionner.
|
|
SRC_HOST=10.100.80.100 # base de facturation legacy live
|
|
SRC_SSH_PW= # mot de passe SSH root de la source
|
|
DB_PW= # mot de passe MySQL root (source ET copie locale)
|
|
DB_NAME=gestionclient
|
|
CONTAINER=legacy-db # nom du conteneur de la copie locale
|
|
TABLES="account delivery service product"
|