to test the import:

# set up the VM:

# start up the vegbiendev VM

ssh -t 128.111.220.240

rm inputs/GBIF/_MySQL/GBIFPortalDB-2013-02-20.data.sql

sudo mkdir -p /var/lib/postgresql/9.3/main/

sudo chown postgres:postgres /var/lib/postgresql/9.3/main/

sudo -E -u postgres /usr/lib/postgresql/9.3/bin/initdb -D /var/lib/postgresql/9.3/main/

sudo ln -sf /etc/postgresql/9.3/main/*.conf /var/lib/postgresql/9.3/main/

make postgres_reload

# at "Modifying postgresql.conf and pg_hba.conf", type y and press ENTER

# at "kernel.shmmax ... Press ENTER to continue", press ENTER

# at "restart PostgreSQL manually ... Press ENTER to continue":

# open a new window

ssh -t 128.111.220.240

# run what it says

# press Ctrl-D

# return to the previous window

# press ENTER

(cd inputs/; for dir in */; do dir="${dir%/}"; case "$dir" in analytical_db|IRMNG|IUCN|newWorld|ARIZ) : ;; *) mv "$dir" .archive/"$dir";; esac; done)

make misc-Linux db inputs/install schemas/public/reinstall

# at "This will delete the current public schema of your VegBIEN DB", type y and press ENTER

# at "If asked for MySQL root password ... Press ENTER to continue", press ENTER