You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
For Linux, the video database will be located at: ~/.kodi/userdata/Database/MyVideosXX.db, where XX is the version number. You will most likely want the highest number available for edit.
SELECT strPath FROMpathWHERE (strPath LIKE'%/path/to/match/%');
SELECT c22 FROM movie WHERE (c22 LIKE'%/path/to/match/%');
SELECT c18 FROM episode WHERE (c18 LIKE'%/path/to/match/%');
SELECT url FROM art WHERE (url LIKE'%/path/to/match/%');
SELECT c16 FROM tvshow WHERE (c16 LIKE'%/path/to/match/%');
SELECT strFilename FROM files WHERE (strFilename LIKE'%/path/to/match/%');
Update paths
UPDATEpathSET strPath = REPLACE(strPath,'/current/path/','/updated/path/');
UPDATE movie SET c22 = REPLACE(c22,'/current/path/','/updated/path/');
UPDATE episode SET c18 = REPLACE(c18,'/current/path/','/updated/path/');
UPDATE art SET url = REPLACE(url,'/current/path/','/updated/path/');
UPDATE tvshow SET c16 = REPLACE(c16,'/current/path/','/updated/path/');
UPDATE files SET strFilename = REPLACE(strFilename,'/current/path/','/updated/path/');
There are URLs in art table of the form image://video@%2fvar%2fmedia%2fmyvideos%2fpath%2fto%2ffile/
with path separator escaped. In order to account for them:
UPDATE art SET url = REPLACE(url,'%2fcurrent%2fpath%2f','%2fupdated%2fpath%2f');
Such paths are also present in texture table (in TexturesXX.db):
UPDATE texture SET url = REPLACE(url,'%2fcurrent%2fpath%2f','%2fupdated%2fpath%2f');
There are URLs in
art
table of the formimage://video@%2fvar%2fmedia%2fmyvideos%2fpath%2fto%2ffile/
with path separator escaped. In order to account for them:
Such paths are also present in
texture
table (inTexturesXX.db
):