+- 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: Lost sql table - how to restore / recreate? (/showthread.php?tid=349201)
Lost sql table - how to restore / recreate? - wannagoOTA - 2019-11-14
Hi
Had a crash and after reboot I lost all watched/unwatched status AND most importantly I lost all cast/actor info. Any one know how to recreate this? I have db backups but I've never used them but I'm willing.
Logfile: https://paste.kodi.tv/mopetaduna.kodi
Thanks for any advice,
ota
RE: Lost sql table - how to restore / recreate? - Karellen - 2019-11-14
What type of DB backups do you have? If it is the full MyVideos116.db (assuming v18) then you can just delete the corrupt database and drop in the backup database.
Databases are located here... Userdata (wiki)
RE: Lost sql table - how to restore / recreate? - wannagoOTA - 2019-11-14
Never mind - sorry to waste your time. I got impatient. Rather than learn SQL I deleted the entire SQL directory and restored from backup. All my other program db's are now out-of-date but they will update. Quick and dirty but it worked. I don't think the scraper would fill data missing from existing entries even if I recreated the table. You may correct me if I'm mistaken.
Peace,
ota
RE: Lost sql table - how to restore / recreate? - wannagoOTA - 2019-11-14
(2019-11-14, 04:10)Karellen Wrote: What type of DB backups do you have? If it is the full MyVideos116.db (assuming v18) then you can just delete the corrupt database and drop in the backup database.
Databases are located here... Userdata (wiki)
Thank you. They are remote mysql db's. I took a more drastic route and restored the entire server db from yesterday's backup.