HOW-TO:Update SQL databases when files move - Revision history

Klojum: /* Updating your Video library */

2021-05-04T07:40:08Z

Updating your Video library

← Older revision		Revision as of 07:40, 4 May 2021
Line 67:		Line 67:
	Open the latest Textures*.db file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest Textures*.db file in your sqlite program, and run the following command (substituting your paths as appropriate):
	UPDATE path SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE path SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');
			UPDATE path SET texture = REPLACE(texture,'smb://my_nas/old_share', 'smb://my_nas/new_share');

	Additionally, if you're updating from a local Windows path to a smb share, you will need to replace backslashes with forward slashes in each of the tables in both databases in order to prevent a future library update from treating the discovered files as different from the existing. For example:		Additionally, if you're updating from a local Windows path to a smb share, you will need to replace backslashes with forward slashes in each of the tables in both databases in order to prevent a future library update from treating the discovered files as different from the existing. For example:

Karellen at 02:43, 8 July 2020

2020-07-08T02:43:53Z

← Older revision		Revision as of 02:43, 8 July 2020
Line 2:		Line 2:
	Kodi has functions to fully manage its database files. Some advanced operations can be performed by editing the database tables directly on your PC. ''Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!'' Make a backup first, and worst-case, you just have to delete the corrupt database file and rescan your music, videos, or programs from within Kodi.<section end="intro" />		Kodi has functions to fully manage its database files. Some advanced operations can be performed by editing the database tables directly on your PC. ''Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!'' Make a backup first, and worst-case, you just have to delete the corrupt database file and rescan your music, videos, or programs from within Kodi.<section end="intro" />

	If you are using a shared mySQL Database on a NAS, please follow this guide instead: [[HOW-TO:~~Share libraries using MySQL/Update Paths In MySQL~~]]		If you are using a shared mySQL Database on a NAS, please follow this guide instead: [[HOW-TO:Update_Paths_In_MySQL]]

	'''Required Software'''		'''Required Software'''
Line 53:		Line 53:

	== Updating your Music library ==		== Updating your Music library ==
	Open the latest [[Databases~~#The_Music_Library~~\|MyMusic*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest [[Databases/MyMusic\|MyMusic*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):
	UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');

	== Updating your Video library ==		== Updating your Video library ==
	Open the latest [[Databases~~#The_Video_Library~~\|MyVideo*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest [[Databases/MyVideos\|MyVideo*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):
	UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');
	UPDATE movie SET c22 = REPLACE(c22,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE movie SET c22 = REPLACE(c22,'smb://my_nas/old_share', 'smb://my_nas/new_share');
Line 72:		Line 72:

	== Updating sources.xml ==		== Updating sources.xml ==
	Edit [[~~Userdata/sources~~.xml\|sources.xml]] in a text editor and do a global search-and-replace for '''smb://my_nas/old_share''' to '''smb://my_nas/new_share'''		Edit [[Sources.xml\|sources.xml]] in a text editor and do a global search-and-replace for '''smb://my_nas/old_share''' to '''smb://my_nas/new_share'''
	[[Category:How-to]]		[[Category:How-to]]
	[[Category:Advanced topics]]		[[Category:Advanced topics]]

Karellen at 08:05, 26 February 2018

2018-02-26T08:05:51Z

← Older revision		Revision as of 08:05, 26 February 2018
Line 53:		Line 53:

	== Updating your Music library ==		== Updating your Music library ==
	Open the latest [[~~XBMC_databases~~#The_Music_Library\|MyMusic*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest [[Databases#The_Music_Library\|MyMusic*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):
	UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');

	== Updating your Video library ==		== Updating your Video library ==
	Open the latest [[~~XBMC_databases~~#The_Video_Library\|MyVideo*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest [[Databases#The_Video_Library\|MyVideo*.db]] file in your sqlite program, and run the following command (substituting your paths as appropriate):
	UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');
	UPDATE movie SET c22 = REPLACE(c22,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE movie SET c22 = REPLACE(c22,'smb://my_nas/old_share', 'smb://my_nas/new_share');

Apaloma: /* Updating your Video library */ Replace your backslashes

2015-10-16T04:51:44Z

Updating your Video library: Replace your backslashes

← Older revision		Revision as of 04:51, 16 October 2015
Line 67:		Line 67:
	Open the latest Textures*.db file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest Textures*.db file in your sqlite program, and run the following command (substituting your paths as appropriate):
	UPDATE path SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE path SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');

			Additionally, if you're updating from a local Windows path to a smb share, you will need to replace backslashes with forward slashes in each of the tables in both databases in order to prevent a future library update from treating the discovered files as different from the existing. For example:
			UPDATE path SET strPath = REPLACE(strPath,'\', '/');

	== Updating sources.xml ==		== Updating sources.xml ==

Apaloma: /* Updating your Video library */ Added update statement for files table

2015-10-16T04:48:30Z

Updating your Video library: Added update statement for files table

← Older revision		Revision as of 04:48, 16 October 2015
Line 63:		Line 63:
	UPDATE art SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE art SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');
	UPDATE tvshow SET c16 = REPLACE(c16,'smb://my_nas/old_share', 'smb://my_nas/new_share');		UPDATE tvshow SET c16 = REPLACE(c16,'smb://my_nas/old_share', 'smb://my_nas/new_share');
			UPDATE files SET strFilename = REPLACE(strFilename,'smb://my_nas/old_share', 'smb://my_nas/new_share');

	Open the latest Textures*.db file in your sqlite program, and run the following command (substituting your paths as appropriate):		Open the latest Textures*.db file in your sqlite program, and run the following command (substituting your paths as appropriate):

Uixtung: XBMC->Kodi; added an another actively updated SQLite software

2015-09-19T21:48:20Z

XBMC->Kodi; added an another actively updated SQLite software

← Older revision		Revision as of 21:48, 19 September 2015
Line 1:		Line 1:
	<section begin="intro" />~~XBMC~~ has functions to fully manage its database files. Some advanced operations can be performed by editing the database tables directly on your PC. ''Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!'' Make a backup first, and worst-case, you just have to delete the corrupt database file and rescan your music, videos, or programs from within ~~XBMC~~.<section end="intro" />		<section begin="intro" />
			Kodi has functions to fully manage its database files. Some advanced operations can be performed by editing the database tables directly on your PC. ''Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!'' Make a backup first, and worst-case, you just have to delete the corrupt database file and rescan your music, videos, or programs from within Kodi.<section end="intro" />
	~~If you are using a shared mySQL Database on a NAS, please follow this guide instead:~~
	* [[HOW-TO:Share libraries using MySQL/Update Paths In MySQL]]

			If you are using a shared mySQL Database on a NAS, please follow this guide instead: [[HOW-TO:Share libraries using MySQL/Update Paths In MySQL]]

	'''Required Software'''		'''Required Software'''

	Two popular SQLite interfaces for Windows are:		Two popular SQLite interfaces for Windows are:
	* [http://~~www~~.~~singular.gr/sqlite~~/ ~~SQLite3Explorer~~]		* [http://sqlitebrowser.org/ DB Browser for SQLite (DB4S), previously known as "SQLite Database Browser" ]
	* [http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLite Spy]		* [http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLite Spy]
			* ''[http://www.singular.gr/sqlite/ SQLite3Explorer (note: last updated 2010)]''

	A capable but unmaintained SQLite client for OSX can be found here:		A capable but unmaintained SQLite client for OSX can be found here:

Ned Scott: /* Assumptions */

2014-12-07T06:59:56Z

Assumptions

← Older revision		Revision as of 06:59, 7 December 2014
Line 19:		Line 19:
	== Assumptions ==		== Assumptions ==

	Let's say you've got all your music stored on shared folder from a PC or NAS (network attached storage), and you've scanned it into the ~~MyMusic75~~.db database. You then changed a drive location, a computer name, etc.:		Let's say you've got all your music stored on shared folder from a PC or NAS (network attached storage), and you've scanned it into the MyMusic##.db database. You then changed a drive location, a computer name, etc.:

	Copy UserData\Database\~~MyMusic75~~.db over to your PC, run SQLite3Explorer, and examine the tables. You'll see that the paths in the table name 'paths', in a field named strPath.		Copy UserData\Database\MyMusic##.db over to your PC, run SQLite3Explorer, and examine the tables. You'll see that the paths in the table name 'paths', in a field named strPath.

	original location: '''smb://my_nas/old_share/Music/Library/...rest of path/filenames'''		original location: '''smb://my_nas/old_share/Music/Library/...rest of path/filenames'''

Hitcher at 15:07, 12 April 2014

2014-04-12T15:07:54Z

← Older revision		Revision as of 15:07, 12 April 2014
Line 9:		Line 9:
	Two popular SQLite interfaces for Windows are:		Two popular SQLite interfaces for Windows are:
	* [http://www.singular.gr/sqlite/ SQLite3Explorer]		* [http://www.singular.gr/sqlite/ SQLite3Explorer]
	* [http://www.yunqa.de/delphi/sqlitespy/index~~.htm~~ SQLite Spy]		* [http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLite Spy]

	A capable but unmaintained SQLite client for OSX can be found here:		A capable but unmaintained SQLite client for OSX can be found here:

Ned Scott at 08:13, 8 April 2014

2014-04-08T08:13:18Z

← Older revision		Revision as of 08:13, 8 April 2014
Line 1:		Line 1:
	~~{{cleanup}}~~		<section begin="intro" />XBMC has functions to fully manage its database files. Some advanced operations can be performed by editing the database tables directly on your PC. ''Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!'' Make a backup first, and worst-case, you just have to delete the corrupt database file and rescan your music, videos, or programs from within XBMC.<section end="intro" />
	XBMC has functions to fully manage its database files. Some advanced operations can be performed by editing the database tables directly on your PC. ''Be forewarned that database tables are relational (inter-related) - do not change any entries unless you are sure of the implications!'' Make a backup first, and worst-case, you just have to delete the corrupt database file and rescan your music, videos, or programs from within XBMC.

	If you are using a shared mySQL Database on a NAS, please follow this guide instead:		If you are using a shared mySQL Database on a NAS, please follow this guide instead:

Ned Scott: Ned Scott moved page HOW-TO:Use your computer to edit XBMC (SQL) database-files to HOW-TO:Update SQL databases when files move

2014-03-04T08:07:21Z

Ned Scott moved page HOW-TO:Use your computer to edit XBMC (SQL) database-files to HOW-TO:Update SQL databases when files move

← Older revision	Revision as of 08:07, 4 March 2014
(No difference)