Revision 12881
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/README.TXT | ||
|---|---|---|
| 475 | 475 |
repeat the above steps |
| 476 | 476 |
**WARNING**: Do not run this until reinstall_all runs successfully |
| 477 | 477 |
on the local machine, or the live DB may be unrestorable! |
| 478 |
update staging table column names: |
|
| 479 |
on local machine: |
|
| 480 |
inputs/run postprocess # runtime: 20 min ("17m48.217s") @starscream
|
|
| 481 |
time yes|make inputs/{NVS,SALVIAS,TEAM}/test # old-style import; runtime: 30 s ("0m28.562s") @starscream
|
|
| 482 |
ssh -t vegbiendev.nceas.ucsb.edu exec sudo su - aaronmk |
|
| 483 |
manually apply schema changes to the live public schema |
|
| 484 |
do steps under "update staging table column names" above |
|
| 478 | 485 |
Sync ERD with vegbien.sql schema: |
| 479 | 486 |
Run make schemas/vegbien.my.sql |
| 480 | 487 |
Open schemas/vegbien.ERD.mwb in MySQLWorkbench |
Also available in: Unified diff
/README.TXT: Schema changes: added steps to update staging table column names on the local machine and vegbiendev