Edit tags via SQL

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Edit tags via SQL

Re: Edit tags via SQL

by Lowlander » Wed Jul 08, 2020 3:53 pm

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.

Re: Edit tags via SQL

by hwassinger » Wed Jul 08, 2020 3:49 pm

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

Re: Edit tags via SQL

by Lowlander » Wed Jul 08, 2020 2:19 pm

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.

Edit tags via SQL

by hwassinger » Wed Jul 08, 2020 2:02 pm

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!

Top