Edit tags via SQL

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

Moderator: Gurus

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

Edit tags via SQL

Post by 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
Posts: 48372
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5
Contact:

Re: Edit tags via SQL

Post by 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.
Lowlander (MediaMonkey user since 2003)
hwassinger
Posts: 9
Joined: Fri Aug 28, 2009 1:42 pm
Contact:

Re: Edit tags via SQL

Post by hwassinger »

ok if I screw up royally can I just restore a copy of the mm.db file?
Lowlander
Posts: 48372
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5
Contact:

Re: Edit tags via SQL

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