+- 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: Req Hard Drive meltdown- lost files (/showthread.php?tid=358738)
Hard Drive meltdown- lost files - PapaJohn - 2020-11-27
One of my hard drives had a meltdown and needlessly to say I lost all the files on the drive.
The info for all those files is in the Kodi database, is there some way of having Kodi generate a report of the now missing files?
Hope someone can help! TIA
RE: Hard Drive meltdown- lost files - Karellen - 2020-11-27
(2020-11-27, 06:15)PapaJohn Wrote: The info for all those files is in the Kodi database, is there some way of having Kodi generate a report of the now missing files?Two options...
1. Create a Smart Playlist (wiki) and the rule is Path Contains whaterver your drive:\\Source is. This will display all your movies on a particular source.
2. If you know your way around SQL, install this and export a list to txt format... https://sqlitebrowser.org/
RE: Hard Drive meltdown- lost files - PapaJohn - 2020-11-27
Don't understand how a smart playlist can extract info for missing files from Kodi's database.
The link for Smart Playlist is blank.
Not familiar with sql.
RE: Hard Drive meltdown- lost files - Karellen - 2020-11-27
(2020-11-27, 06:57)PapaJohn Wrote: The link for Smart Playlist is blank.meant to be plural Smart Playlists (wiki)
(2020-11-27, 06:57)PapaJohn Wrote: Don't understand how a smart playlist can extract info for missing files from Kodi's database.It won't give you "missing files" it will give you a list of movies that were on that drive.
RE: Hard Drive meltdown- lost files - PapaJohn - 2020-11-27
OK once the smart playlist is generated can it be exported to be printed out?
RE: Hard Drive meltdown- lost files - Karellen - 2020-11-27
No.
You will need to use the SQL method if you want to print out a list.
RE: Hard Drive meltdown- lost files - Klojum - 2020-11-27
It'll be a bit rudimentary, and there will be no need for a smart playlist, but you can open your music database file MyMusic72.db with most SQLite database tools, and run the following command:
SELECT * FROM path WHERE strPath LIKE "%DRIVEPATH%"Mind you, change DRIVEPATH to whatever harddisk name the problem drive has/had, and a list should follow.
Do keep the %-signs at either side in the command. The listing could then be copied to whatever text editor and be printed out.
RE: Hard Drive meltdown- lost files - jmgibson1981 - 2020-11-27
For future to avoid this issue if you keep your media on multiple drives I'd suggest you look into https://www.snapraid.it/
Been using it at home. Haven't had a disk fail yet but I have tested the restoration process. Is a snapshot Raid with up to 6 parity disks / levels. Is worth it. I know I have no desire to re-rip 2000+ dvd's & cds if I don't have to.
RE: Hard Drive meltdown- lost files - PapaJohn - 2020-12-02
Thanks to all for your help. The SQL method worked a treat. I now have a printed list of all the missing files!