5

I like to extract playlist information (i.e. path and filenames) I've created on Android's builtin MP3-player, to copy it with the MP3 files to a bigger SDHC card. Playlist information is lost when doing this:

  • Removing the SDHC memory card (after turning off the device), and re-insert it later, causes the MP3-player to forget all files in the playlists which I have created. This is especially annoying if you want to replace the SDHC card by a bigger one and want to backup all files including playlists from the old one

Hence I am looking for a way to backup the playlists or at least their content (i.e. path filename etc).


More information:

The phone has a playlist folder, containing the Playlists, when I use a USB cable to connect it to the PC, I can see them (*.pla files) but they have 0 bytes and cannot be copied. Also, if I connect the SDHC card via cardreader, the files aren't useful.

Samsung Kies also did not work for me, it does not seem to support the playlists created on the phone.

I found this interesting question, which explains that Android stores playlists in SqlLite databases, but unfortunately, on my Samsung phone I could not find the database file (although there is a folder Computer\GT-I8190\Phone\Android\data\com.google.android.music which should contain it, but no databases subdirectory and no database files).

N.B.: The smarthphone is able to read and import *.m3u playlists (via the player's "Music Square" menu - context menu "Library update"), but cannot modify them (if you add titles, they will only be available in the smartphone, the *.m3u file isn't changed).


To summarize my question (one of the options below would help me):

  • Do you know how I can backup the playlists on the phone and then extract the file/path info contained in them in Windows?
    Phone Playlist -> Windows PC -> Extract Path/Filename to text file

  • Or do you know if there is a tool available (for Android, or for Windows reading it from the mobile phone) converting the playlists into a compatible text format (like .m3u playlists)?
    Phone Playlist -> M3U file

    (Note: The other way round it is possible, as this forum post explains). Here's an example of a M3U file, note that relative paths are allowed as well:

    #EXTM3U
    #EXTINF:123, Sample artist - Sample title
    /storage/extSdCard/Sounds/Sample.mp3


Your help is much appreciated!

1
  • Andrew's answer of Dec 14 works very well for list that use the standard Android db. I had to recreate my Amazon and Google music list using Music Player. Then used PlaylistSync to backup the list to my Google drive. Now for the first time I feel like I have recreated my playlist for the last time.
    – BroPage
    Oct 28 '18 at 16:10
3

Playlists are stored in a SQLite database in /data/data/com.android.providers.media/databases/external.db.

I've made a Python script to convert the audio playlist from this database to M3U, it's called m3truid. You need a PC and ADB enabled.

Not as nice as an Android app but especially useful when your screen is dead.

1
  • Are you still able to access this .db file?
    – brasofilo
    Sep 2 '18 at 16:14
0

There was no answer provided yet, so here's what I found out by myself so far. It is rather an idea how it could be solved.

The solution is to write an Android player app, which has access to the playlist database through the Android API. This app can read the properties of the playlist and save path, filename, title artist etc into a text file, preferrably M3U format.

At AndroidHive.info I found the source code for an android MP3 player, not including the feature mentioned above. But I am sure it can be implemented with some effort.


Update: Andrew has kindly provided an answer, which directly solves the issue. However, I keep this answer in case someone likes to develop a player on his/her own which will include a playlist import/export. Just use the link above which will take you to the source code.

Not the answer you're looking for? Browse other questions tagged or ask your own question.