Kodi media player - update video database file paths

• The Kodi databases are all SQLite3 based.
• 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.

Install SQLite CLI tools, open database

$ sudo apt-get install libsqlite3-dev sqlite3
$ sqlite3 MyVideosXX.db

Queries

List paths

SELECT strPath FROM path WHERE (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

UPDATE path SET 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/');

Reference

• http://kodi.wiki/view/HOW-TO:Update_SQL_databases_when_files_move