Reload database from dumpΒΆ

  • Go to the project root directory on your virtual machine:

    cd /protwis/sites/protwis
    
  • Delete the current database (password: protwis):

    psql -U protwis -h localhost -d protwis -c 'drop schema public cascade; create schema public;'
    
  • [Optional] Download the newest dump from gpcrdb:

    curl http://files.gpcrdb.org/protwis_sp.sql.gz > ~/protwis.sql.gz
    gunzip ~/protwis.sql.gz
    
  • Load the dump (Either from default location or a location of your choosing):

    psql -U protwis -h localhost -o protwis < ~/protwis.sql;