Instructions to start from scratch with VM #23?

database
schemachange
musicbrainz-vm
vm
instructions
Tags: #<Tag:0x00007f23c2656d40> #<Tag:0x00007f23c2656bd8> #<Tag:0x00007f23c2656a98> #<Tag:0x00007f23c2656908> #<Tag:0x00007f23c26567c8>

#1

The latest available VM (2016-12-20) comes with schema #23.

I can’t find the necessary instructions to empty the existing data in the VM musicbrainz database, upgrade to #24 and import the latest full dump from http://ftp.musicbrainz.org/pub/musicbrainz/data/fullexport/

Maybe someone from the community who has already done this successfully can share this steps and commands?


#2

Instructions for the upgrade are on the blog.

Michael


#3

Which commands exactly do I need for the VM to
a) Clear the actual database?
b) Import a full dump?
Maybe I’m blind, but I can’t see the steps in the blog instructions (which is for a fully replicated DB with #23 and therefore only a few missing replication packets for #24).
I’m looking for the commands for clearing/full dump import the VM database.


#4

In broad strokes, you need to:

  1. Change the DB_SCHEMA_SEQUENCE setting to 24.
  2. Drop the database.
  3. Import the database.

There are a few additional steps from the upgrade blog post that you need to do, but I can’t tell you the exact sequence because of how I had to do my upgrade while troubleshooting the older NodeJS version issue. Someone else might be able to fill in those details.

Michael