Edit tags via SQL

Get answers about using the current release of MediaMonkey for Windows.

Moderator: Gurus

hwassinger
Posts: 3
Joined: Fri Aug 28, 2009 1:42 pm

Edit tags via SQL

Post 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!

Lowlander
Posts: 47522
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Edit tags via SQL

Post 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.
Lowlander (MediaMonkey user since 2003)

hwassinger
Posts: 3
Joined: Fri Aug 28, 2009 1:42 pm

Re: Edit tags via SQL

Post 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?

Lowlander
Posts: 47522
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Edit tags via SQL

Post 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.
Lowlander (MediaMonkey user since 2003)

Post Reply