Where are playlists located?

johandenver · Post by **johandenver** » Wed Dec 14, 2005 3:15 am

Hi!

Is it possible to move a created custom playlist from one computer to another? Sort of like exporting it?
Are they actually files I can copy or is it embedded in MM?

/Johan

trixmoto · Post by **trixmoto** » Wed Dec 14, 2005 4:48 am

They are stored in the database I believe. There are however scripts for exporting to a number of different filetypes including PLS and M3U.

johandenver · Post by **johandenver** » Wed Dec 14, 2005 4:57 am

Yes, I tried exporting it but then it just exports the songs in a playlist and not the playlistconfiguration itself, which is what I want.

The problem is that when I reinstall MM sometimes, my playlists all vanish and there seems to be no way to backup them up.
I don't want to use a backup of the MM-database unless I'm forced to.
I like the whole installation to be as "fresh" as possible

/Johan

trixmoto · Post by **trixmoto** » Wed Dec 14, 2005 5:59 am

Maybe somone could write a script to export the relevant database table and another to import them. Would take more SQL knowledge than I have though. And playing with the database directly is not a wise idea.

What information do these scripts fail to export/import?

johandenver · Post by **johandenver** » Wed Dec 14, 2005 6:42 am

It fails to export the information about how the playlist is set up.
I'd like to be able to export the criterias of an autoplaylist to another
computer without having to create it all over again.
The only info that comes from an export is what songs match the criterias but that's not really the information I want.

Lets say I create an autoplaylist searching for all songs with a rating of 4 and higher within the genres pop & rock.
It would be great to just be able to do "Save as" and get a file to import on another computer to do a similar search on that database.
When you have 30 different autoplaylists it can be kind of annoying having to create them all over again when MM have to be reinstalled.

Maybe this is something for the wishlist then?

/Johan

onkel_enno · Post by **onkel_enno** » Wed Dec 14, 2005 7:00 am

@Johan
If you deinstall MM, the playlists will still remain. They aren't deleted.
They are saved within My Documents\My Music\MediaMonkey\MediaMonkey.mdb.
If you really want to backup the palylists, then you should backup this file.

trixmoto · Post by **trixmoto** » Wed Dec 14, 2005 7:36 am

johandenver wrote:I don't want to use a backup of the MM-database unless I'm forced to. I like the whole installation to be as "fresh" as possible

@onkel_enno: Where are the criteria saved? I couldn't find them in the database. Which table?

onkel_enno · Post by **onkel_enno** » Wed Dec 14, 2005 8:52 am

Open the Table Playlists and resize the field Querydata - not in width but in height -> Surprise

If you don't want to backup the whole library (thx trixmoto for the hint) then I'm sure trixmoto will create a script the saves them for you in a textfile or so

johandenver · Post by **johandenver** » Wed Dec 14, 2005 9:00 am

If trixmoto could do that I would be very grateful.
But I would also need and script that could import the textfile then
otherwise it would be of little use.
Thanks for your time, both of you.

/Johan

trixmoto · Post by **trixmoto** » Wed Dec 14, 2005 9:26 am

That is quite surprising!

My logic had taken me to that field, but when I extended it width-ways and found nothing I gave up - silly me!

If you could provide me with the SQL statements onkel_enno I would be happy to create the script. I might be ok with the "select" statement, but definitely not happy with creating the "insert" (is it?) statement.

Steegy · Post by **Steegy** » Wed Dec 14, 2005 9:31 am

I don't want to sound "lazy" or something, but isn't it much easier to just export the Playlists table from the MM database to a new database?
This can then easily be imported or "pasted" back.

Cheers
Steegy

trixmoto · Post by **trixmoto** » Wed Dec 14, 2005 9:55 am

This is a very good point. In Access if you right-click on the "Playlists" table you can select "Export" from the context-menu.

Then you'd click "File, Get External Data, Import" to import the saved file.

onkel_enno · Post by **onkel_enno** » Thu Dec 15, 2005 1:38 am

What if johandenver has no MS Access?

For me, I would only backup the .mdb and everything is fine.

@trixmoto

Code: Select all

Insert Into Playlists (Playlistname, IsAutoPlaylist, QueryData) Values ('Huhu', 1, "[Common]
QueryVersion=1
...")

johandenver · Post by **johandenver** » Thu Dec 15, 2005 7:10 am

I do not have MS Acess

trixmoto · Post by **trixmoto** » Mon Dec 19, 2005 11:48 am

I'm sorry but I can't work out how to get the textdata itself out of the database.