How to import cover art archive dump?

xeitor · March 20, 2025, 10:51pm

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.

InvisibleMan78 · March 21, 2025, 1:08pm

Are you looking for something like this?

And this can maybe help you to see the CreateTable content:

github.com/metabrainz/musicbrainz-server

admin/sql/caa/CreateTables.sql

master

\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

InvisibleMan78 · March 21, 2025, 1:19pm

You could also have a look at the MB docker container:

xeitor · March 23, 2025, 3:24pm

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.