xeitor
March 20, 2025, 10:51pm
1
Hi there, hope you are all doing great.
I am on the quest to have a very complete MusicbBrainz and ListenBrainz local setup. And I am now trying to import a dump for the cover_art_archive scheme, I downloaded a dump and was wondering how can I import it to MusicBrainz db.
Thanks in advance.
1 Like
Are you looking for something like this?
And this can maybe help you to see the CreateTable content:
\set ON_ERROR_STOP 1
BEGIN;
SET search_path = 'cover_art_archive';
CREATE TABLE art_type ( -- replicate (verbose)
id SERIAL NOT NULL, -- PK
name TEXT NOT NULL,
parent INTEGER, -- references cover_art_archive.art_type.id
child_order INTEGER NOT NULL DEFAULT 0,
description TEXT,
gid uuid NOT NULL
);
CREATE TABLE image_type ( -- replicate (verbose)
mime_type TEXT NOT NULL, -- PK
suffix TEXT NOT NULL
);
Diese Datei wurde abgeschnitten. Original zeigen
You could also have a look at the MB docker container:
Docker Compose project for the MusicBrainz Server with replication, search, and development setup
xeitor
March 23, 2025, 3:24pm
4
thanks @InvisibleMan78 for the info, I tried the docker environment but most of the times I prefer a native setup.
i already have created the tables in the db but now I would like to import some rows in it.