path file locations update in sql
#1
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?
Reply
#2
There is an outdated Wiki page about upgrading paths in MySQL: HOW-TO:Update_Paths_In_MySQL (wiki)
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.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
#3
(2019-11-25, 23:06)Klojum Wrote: There is an outdated Wiki page about upgrading paths in MySQL: HOW-TO:Update_Paths_In_MySQL (wiki)
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?
Reply
#4
(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.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
path file locations update in sql00