How to read the database outside of Mediamonkey?

[gruff]

Forgive the total noob question. I tragically lost the hard drive all my music was on, and the MM5 database is the only surviving record of what I had. I'd like to be able to see it in a legible format so I can go about rebuilding my collection. I tried opening it in Notepad but it was a mess. What is the best program or way to convert it to something human readable?

Thanks in advance for your help.

[sonos]

@ How to read the database outside of Mediamonkey?

You can use any SQLite editor (I personally use the DBeaver SQL Client software)

[Rob_S]

There might be an easier way. The MM database contains all kinds of stuff you don't need.

First make sure you have copied the database to a backup location. The following should not affect it, but just to be safe.

Next, open Mediamonkey, click on "All Tracks" in the media tree, then "Ctrl+A" to select all your listed tracks.

Then under file menu, reports, file list, choose which fields you want, and then OK, chose file type csv, give it a name, and save.

You can then open this csv file in your spreadsheet, where you can sort, markup, etc

[gruff]

Gentlemen, thank you for your assistance. Was not familiar with SQL. The second option worked a charm too, did not delete original database, and the ability to choose which fields are exported is just great. I am now embarked on a five year mission to recreate my 450 GB collection!

[Rob_S]

Have you considered professional data recovery attempts on that "lost" drive?

Surely something would be salvageable, unless it is actually missing or broken into small particles....

[gruff]

Yeah it's physically missing, as in I don't know where it is. I can't even figure out exactly how I lost it. There's a tiny chance it's in my house somewhere, I nurture a small hope I might still find it, but most likely it's gone.

[reithner]

"Then under file menu, reports, file list, choose which fields you want"

When I get to file list I only get the option to select the output type, i.e., XML, HTML, CSV, EXCEL. There's no option to select field. I'm trying to extract a list of all genres in my library so I can select the ones I want and migrate badly tagged files to approved genres. If I generate a report including all fields, the default option, I only get the first 12,888 records, out of over 200K. I thought if I could select only genre I might be able to download more rows.

[Lowlander]

The first screen should allow for column selection, if you don't see this, what Build (Help > About) of MediaMonkey are you using?