+- 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: path file locations update in sql (/showthread.php?tid=349552)
path file locations update in sql - dr-oopie - 2019-11-25
im updating my nas and the paths have changed. is there any software that can do this or do i have to do the sql search and replace method?
RE: path file locations update in sql - Klojum - 2019-11-25
There is an outdated Wiki page about upgrading paths in MySQL: https://kodi.wiki/view/HOW-TO:Update_Paths_In_MySQL
You'll need to browse most tables for replacing paths.
It's recommended that you also delete the thumbnail cache as well as the local Textures13.db file, as all caching is done based of file paths.
RE: path file locations update in sql - dr-oopie - 2019-11-26
(2019-11-25, 23:06)Klojum Wrote: There is an outdated Wiki page about upgrading paths in MySQL: https://kodi.wiki/view/HOW-TO:Update_Paths_In_MySQLdo you happen to know what table contains paths?
You'll need to browse most tables for replacing paths.
It's recommended that you also delete the thumbnail cache as well as the local Textures13.db file, as all caching is done based of file paths.
RE: path file locations update in sql - Klojum - 2019-11-26
(2019-11-26, 03:57)dr-oopie Wrote: do you happen to know what table contains paths?
A bit of browsing through the database will get you that info too.
episode / movie / musicvideo / path
These tables have one or more fields with path references to full filenames in them.