Kodi Community Forum

Full Version: path file locations update in sql
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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?
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.
(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_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.
do you happen to know what table contains paths?
(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.