+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Where KODI stored video bookmarks? (/showthread.php?tid=271412)
Where KODI stored video bookmarks? - FreakMurderer - 2016-04-26
Where KODI stored video bookmarks?
What file ?
RE: Where KODI stored video bookmarks? - black_eagle - 2016-04-26
In the bookmarks table, in the video database.
RE: Where KODI stored video bookmarks? - FreakMurderer - 2016-04-26
Where i can find this file ?
What app can open it?
RE: Where KODI stored video bookmarks? - black_eagle - 2016-04-26
It is not a file, it is an SQLite3 relational database. And I wouldn't advise editing it unless you are 100% certain you know what you are doing.
See database (wiki).
RE: Where KODI stored video bookmarks? - FreakMurderer - 2016-04-26
I know about sql databases....
RE: Where KODI stored video bookmarks? - black_eagle - 2016-04-26
(2016-04-26, 18:04)FreakMurderer Wrote: Where i can find this file ?
What app can open it?
(2016-04-26, 19:04)FreakMurderer Wrote: I know about sql databases....
Then I assume you know what apps can open it then
RE: Where KODI stored video bookmarks? - BobMcK - 2019-04-09
(2016-04-26, 21:54)black_eagle Wrote:(2016-04-26, 18:04)FreakMurderer Wrote: Where i can find this file ?
What app can open it?(2016-04-26, 19:04)FreakMurderer Wrote: I know about sql databases....
Then I assume you know what apps can open it then
I myself am a retired database developer and could figure this out if I needed to, but I only have a few questions before I go that route. If I bookmark a video, but change the file name or move the file to a different drive, the bookmarks disappear. This tells me that the database entry for bookmarks uses the full path name for the file. Is this true or not? Presuming I could fire up some sort of SQL processor and hack the database, might I be able to take out the drive part of the path name so no matter what drive the file is on, as long as I don't change the file name, the bookmarks would still be available? Would be helpful to know if anybody out there can answer.
RE: Where KODI stored video bookmarks? - Klojum - 2019-04-09
The bookmark table used the idFile of the video file. Changing a name or any part of the (network) path to the video, will result in a new video idFile value in the database. And hence, the old bookmark is no longer viable.
RE: Where KODI stored video bookmarks? - BobMcK - 2019-04-10
(2019-04-09, 19:52)Klojum Wrote: The bookmark table used the idFile of the video file. Changing a name or any part of the (network) path to the video, will result in a new video idFile value in the database. And hence, the old bookmark is no longer viable.Thanks! Very helpful! Is the idFile generated by Kodi or by android?
RE: Where KODI stored video bookmarks? - Klojum - 2019-04-10
It's generated by Kodi. I should hope that Android's nosiness will never go that far.
RE: Where KODI stored video bookmarks? - BobMcK - 2019-04-10
(2019-04-10, 11:49)Klojum Wrote: It's generated by Kodi. I should hope that Android's nosiness will never go that far.
LOL. Do you know if there is a way to generate the fileID on demand? Could then find out what it is and do a UPDATE tablename SET fieldname = 'newvalue' WHERE FIELDNAME = 'oldvalue'. Might even make it worth my while to get back into C++ (?). Now where's that compiler....
RE: Where KODI stored video bookmarks? - Klojum - 2019-04-10
You could have seen it already if you had a look at the MyVideos database. The idFile field in 'files' is an autoincrement value, in MySQL at least. In SQLite, I don't know.
RE: Where KODI stored video bookmarks? - BobMcK - 2019-04-10
(2019-04-10, 15:49)Klojum Wrote: You could have seen it already if you had a look at the MyVideos database. The idFile field in 'files' is an autoincrement value, in MySQL at least. In SQLite, I don't know.
OK thanks. Right now, I'm running Kodi on a Minix, which is kind of balky. Thinking also of getting a Windows laptop to take its place.