Revision 5461
Added by Aaron Marcuse-Kubitza over 12 years ago
| README.TXT | ||
|---|---|---|
| 36 | 36 |
Important: This must be done *after* running make_analytical_db |
| 37 | 37 |
Rename the rotated schema using the date in the first datasource's log |
| 38 | 38 |
file name |
| 39 |
tail inputs/{.,}*/*/logs/<date>-*.log.sql
|
|
| 39 |
tail inputs/{.,}*/*/logs/*.r<revision>[.-]*log.sql
|
|
| 40 | 40 |
Check that every input's log ends in "Encountered 0 error(s)" |
| 41 | 41 |
If many do not, fix the bug and discard the current (partial) import: |
| 42 | 42 |
make schemas/public/reinstall |
| 43 | 43 |
Otherwise, continue |
| 44 | 44 |
Delete previous imports so they won't bloat the full DB backup: |
| 45 |
make backups/public.<datetime>.backup/remove
|
|
| 45 |
make backups/public.<version>.backup/remove
|
|
| 46 | 46 |
make inputs/.TNRS/cleanup; make backups/TNRS.backup-remake & |
| 47 |
make backups/public.<datetime>.backup/test &
|
|
| 48 |
make backups/vegbien.<datetime>.backup/test &
|
|
| 47 |
make backups/public.<version>.backup/test &
|
|
| 48 |
make backups/vegbien.<version>.backup/test &
|
|
| 49 | 49 |
On local machine: |
| 50 | 50 |
make inputs/download-logs tnrs_log=1 |
| 51 | 51 |
make backups/download |
| ... | ... | |
| 54 | 54 |
Open inputs/import.stats.xls |
| 55 | 55 |
Insert a copy of the leftmost Column-based column group before it |
| 56 | 56 |
Update the import date in the upper-right corner |
| 57 |
./bin/import_times inputs/{.,}*/*/logs/<date>-*.log.sql
|
|
| 57 |
./bin/import_times inputs/{.,}*/*/logs/*.r<revision>[.-]*log.sql
|
|
| 58 | 58 |
Paste the output over the # Rows/Time columns, making sure that the |
| 59 | 59 |
row counts match up with the previous import's row counts |
| 60 | 60 |
If the row counts do not match up, insert or reorder rows as needed |
Also available in: Unified diff
README.TXT: Use new revision # in log filenames to get all the logs for an import. Changed <datetime> to <version> because the rotated public schema now also includes the svn revision.