Database Dump: How can I match recordings with their "release group"?

database
sql
Tags: #<Tag:0x00007f2a05e31210> #<Tag:0x00007f2a05e30e78>

#1

I have downloaded and extracted MusicBrainz’s database dump files (mbdump and mbdump-derived).

I am using MySQL. I have imported the “recording” and “release_group” tables—among others—and I don’t see how I can match a recording db record with recording group. The “recording_release_group” table seems to be the answer, but I can find it any of the db files I have downloaded.

I would appreciate some help figuring this out.


#2

Release group > Release > Medium > Track > Recording.

See https://musicbrainz.org/doc/MusicBrainz_Database/Schema for a schema diagram.