Topic: Where is the schema for the data dump?
I spent several hours attempting to use the information here along with the tab delimited data dump:
I manually typed out all those tables and fields and created the database in mysql along with the indices, but the files in mbdump.tar.bz2 don't match the documented schema information exactly.
1. While some of the schema ngs.png image seems correct, several extra fields exist or are referring to a different field name (i.e. wrong order) in some of the tables such as release, recording and others. I wish the data dump contained the current schema information in SQL or just a list of field names/data types for each table as a separate file for reference.
2. Additionally, I see no way to associate the tracks with the album name. The charts provided don't describe such a relationship, yet the musicbrainz web site does have this ability to navigate from artist to releases to viewing the track names and other details.
I'm attempting to download the musicbrainz server OVA image instead to see if that works better.
If there is a better place to discuss this, please let me know.