Lost table of artists and albums but got recordings... Can I reverse query using the app?

Tags: #<Tag:0x00007f73a9cf9170>

Hello all, so have been using the api to get artists->albums->tracks and save them in MySQL DB

Long story short, after 29k tracks and more than 19k albums and nearly 900 bands, I lost my artist table and albums table… All I have is the tracks (recording) table that contains mbid of each recording, position in the album…
Is there a way to use this information to restore my albums and bands using the api?

Any guidance is appreciated

Edit: typos

You can do a lookup of recordings to see what the artist is for that track.
You can also get a list of albums this recording was found on and this can be a large list and include compilations.
There may be several editions of a release ie the base release, a release with bonus tracks, a different edition in another country etc so you may need to decide what release is the one you want.

First lookup the recording to get the artist and the list of releases
https://musicbrainz.org/ws/2/recording/833f00e1-781f-4edd-90e4-e52712618862?inc=artists+releases&fmt=json
Next look up the release to get the track list
https://musicbrainz.org/ws/2/release/e0aec533-0eb3-49ed-8293-4d650d2aa4eb?inc=recordings&fmt=json

2 Likes