Refreshing VegBank--a SQL plots datasource¶

steps¶

from README.TXT > Single datasource refresh

1. connect to vegbiendev:
   

   ssh -t vegbiendev.nceas.ucsb.edu exec sudo -u aaronmk -i
   

2. obtain updated extract
   

   inputs/VegBank/run refresh
   

3. reload staging tables:
   

   rm=1 inputs/VegBank/run
   

4. run column-based import:
   

   make inputs/VegBank/reimport_scrub by_col=1 & # runtime: 15 min ("14:45.73")
   tail -150 inputs/VegBank/*/logs/public.log.sql # view progress
   

5. see README.TXT > Single datasource refresh > steps after reimport_scrub