Revision 6367
Added by Aaron Marcuse-Kubitza about 12 years ago
| README.TXT | ||
|---|---|---|
| 22 | 22 |
Update the schemas: make schemas/reinstall |
| 23 | 23 |
WARNING: This will delete the current public schema of your VegBIEN DB! |
| 24 | 24 |
To save it: make schemas/rotate |
| 25 |
Important: This must be done *after* running make_analytical_db on a |
|
| 26 |
previous import |
|
| 27 | 25 |
Start column-based import: . bin/import_all by_col=1 |
| 28 | 26 |
To use row-based import: . bin/import_all |
| 29 | 27 |
To stop all running imports: . bin/stop_imports |
| ... | ... | |
| 40 | 38 |
Determine the import name: |
| 41 | 39 |
bin/import_name inputs/{.,}*/*/logs/*.r<revision>[.-]*log.sql
|
| 42 | 40 |
Archive the last import: make schemas/rename/public.<import_name> |
| 43 |
Important: This must be done *after* running make_analytical_db |
|
| 44 | 41 |
Delete previous imports so they won't bloat the full DB backup: |
| 45 | 42 |
make backups/public.<version>.backup/remove |
| 46 | 43 |
make backups/TNRS.backup-remake & |
| ... | ... | |
| 59 | 56 |
If the row counts do not match up, insert or reorder rows as needed |
| 60 | 57 |
until they do |
| 61 | 58 |
Commit: svn ci -m "inputs/import.stats.xls: Updated import times" |
| 62 |
To remake analytical DB: bin/make_analytical_db & |
|
| 59 |
To remake analytical DB: env public=... bin/make_analytical_db & |
|
| 60 |
public should be set to the current import's schema name |
|
| 63 | 61 |
To view progress: |
| 64 | 62 |
tail -f inputs/analytical_db/logs/make_analytical_db.log.sql |
| 65 | 63 |
|
Also available in: Unified diff
README.TXT: Data import: To remake analytical DB: Added explicit public schema setting since the analytical DB is often manually remade after the public schema has been renamed. Removed warnings that certain commands must be run after running make_analytical_db, because the "remake analytical DB" instructions no longer require this.