Edit tags via SQL

[hwassinger]

I have a library of approximately 68,000 tracks. A large number have various and sundry tags missing but the data is a part of the filename.

Is there a way to access / edit the database using MS Access, or SQL?

For example I have the following that I could parse and then update the tags.

"F:\Music\Joan Jett Full Discography with Lives\1983 - Album\01 - Joan Jett And The Blackhearts - Fake Friends.mp3"

Thanks!

[Lowlander]

You can use Tools > Auto-Tag from Filename to get tag info from filename: https://www.mediamonkey.com/wiki/index. ... lename/4.0 and I assume RegExp can also help with this: https://www.mediamonkey.com/forum/viewt ... lit=regexp

The database is SQLite and there are topics on using this.

[hwassinger]

ok if I screw up royally can I just restore a copy of the mm.db file?

[Lowlander]

Depends, if you're just modifying tags they will be saved to the files too (default setting), but you could re-save (current values) with backup copy of database.

Note that Auto-Tag from Filename will show the changes it will make before applying them.