vlc_media.db and SQlite Browser/Editor

[JiiP]

Hello everyone.

First of all I want to thank the VLC team for creating the best tool that exists in my opinion. Second, I want to apologize if this question has already been answered elsewhere, but I couldn't find what I was looking for. As you might already have guessed I'm absolutely not familiar with databases, so I'm seriously struggling and consequently I have several questions running around my head.

To put things into perspective, I've always used a SD card in my phone to store my data, may it be documents, pictures, music or other medias. At first, 10 years ago, it was because the internal storage of phones didn't have the capacity, or did but were too expensive, and with time it became an ethical question for me, as I refuse to store in the cloud for obvious environmental reasons.

So here's my problem: Every time I change my phone, every 5 years or so, I lose all my painstakingly created playlists. Reading forums and FAQs I learned how to dump the vlc_media.db to the root folder before switching phones. Since my new phone is still under warranty, I also refuse to root it, logically. That of course means I can't copy the file into the new phone.

When I open the file in SQlite browser on my Windows 10 computer, under the tab "Browse data" and selecting the table "Playlist", I can view the different playlists, their names and how many items are inside each of them, but I can't for the life of me find WHICH items they are. To make myself perfectly understood where is the information about the content of each playlists available?

I just want to recreate the playlists on the new phone directly from the app, but I need to know their original content, nothing more.

Some help would be greatly appreciated.

Best regards

[Aza]

Backup/restore for playlist and bookmark is indeed not supported yet. We should add it in a future version.

[Heat8488]

How come editing vlc_media.db was supported and then Unsupported? Is the database encrypted? The SQL editors I use all say it's not a database.

[Aza]

What do you mean? Editing the db was never (and will never be) supported.
vlc_media.db can be opened to look into it though. I do it everyday with "DB Browser for SQLite" on Linux.

[JiiP]

@Aza

I never asked for support to edit the db, nor to import it. I'm also using DB Browser for SQLite but on Windows.

My original question was: how can I use the DB Browser to just VIEW the items contained in the playlists? I see the names of the playlists and how many items they contain, but I can't find out which items they are.

[Aza]

Use the PlaylistMediaRelation table to get media and playlist ids. You can then look into the Media table to find the media by id.

[Lotesdelere]

How come editing vlc_media.db was supported and then Unsupported? Is the database encrypted? The SQL editors I use all say it's not a database.

It's opening fine with the free and open source SQLiteStudio as well as DB Browser.