vlc_media.db and SQlite Browser/Editor
Posted: 31 Dec 2023 16:51
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
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