# Instructions to start from scratch with VM #23?

**URL:** https://community.metabrainz.org/t/instructions-to-start-from-scratch-with-vm-23/270410
**Category:** Development
**Tags:** database, musicbrainz-vm, schemachange, vm, instructions
**Created:** [May 18, 2017, 12:31pm UTC](https://community.metabrainz.org/t/instructions-to-start-from-scratch-with-vm-23/270410 "2017-05-18T12:31:32Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![InvisibleMan78](https://community.metabrainz.org/letter_avatar_proxy/v4/letter/i/c67d28/32.png) [@InvisibleMan78](https://community.metabrainz.org/u/InvisibleMan78)
#### Post date: [May 18, 2017, 12:31pm UTC](https://community.metabrainz.org/t/instructions-to-start-from-scratch-with-vm-23/270410/1 "2017-05-18T12:31:32Z")

</div>

The latest available [VM](https://musicbrainz.org/doc/MusicBrainz_Server/Setup) (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 [Index of /pub/musicbrainz/data/fullexport/](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?

---

<div class="post-metadata">

### Author: ![msl521](https://community.metabrainz.org/letter_avatar_proxy/v4/letter/m/3be4f8/32.png) [@msl521](https://community.metabrainz.org/u/msl521)
#### Post date: [May 18, 2017, 2:05pm UTC](https://community.metabrainz.org/t/instructions-to-start-from-scratch-with-vm-23/270410/2 "2017-05-18T14:05:17Z")

</div>

Instructions for the upgrade are [on the blog](https://blog.musicbrainz.org/2017/05/16/schema-change-release-2017-05-15-including-upgrade-instructions/).

Michael

---

<div class="post-metadata">

### Author: ![InvisibleMan78](https://community.metabrainz.org/letter_avatar_proxy/v4/letter/i/c67d28/32.png) [@InvisibleMan78](https://community.metabrainz.org/u/InvisibleMan78)
#### Post date: [May 18, 2017, 2:20pm UTC](https://community.metabrainz.org/t/instructions-to-start-from-scratch-with-vm-23/270410/3 "2017-05-18T14:20:25Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![msl521](https://community.metabrainz.org/letter_avatar_proxy/v4/letter/m/3be4f8/32.png) [@msl521](https://community.metabrainz.org/u/msl521)
#### Post date: [May 18, 2017, 2:27pm UTC](https://community.metabrainz.org/t/instructions-to-start-from-scratch-with-vm-23/270410/4 "2017-05-18T14:27:56Z")

</div>

In broad strokes, you need to:

1. Change the DB\_SCHEMA\_SEQUENCE setting to 24.
2. Drop the database.
3. [Import the database](https://github.com/metabrainz/musicbrainz-server/blob/master/INSTALL.md#creating-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
