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

Tags: #<Tag:0x00007f7d02f97500> #<Tag:0x00007f7d02f97118>

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.

Release group > Release > Medium > Track > Recording.

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

2 Likes