MySQL/Setting up Kodi - Revision history

Kambala: fixed redv element

2023-04-20T16:45:30Z

fixed redv element

← Older revision		Revision as of 16:45, 20 April 2023
Line 23:		Line 23:
	{{note\|You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in Kodi.}}		{{note\|You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in Kodi.}}

	{{redv\|'''Warning:''' \|This will create individual ".nfo" and image files along side your video files. This is considered the safest way to backup and/or migrate a library (MySQL or otherwise), but some users might not want the file clutter.		{{redv\|'''Warning:''' \|This will create individual ".nfo" and image files along side your video files. This is considered the safest way to backup and/or migrate a library (MySQL or otherwise), but some users might not want the file clutter.}}

	#Open Kodi on the computer that has the library you want to share		#Open Kodi on the computer that has the library you want to share

Karellen at 00:29, 24 August 2020

2020-08-24T00:29:15Z

← Older revision		Revision as of 00:29, 24 August 2020
Line 6:		Line 6:
	{{-}}		{{-}}
	==Make files accessible over the network==		==Make files accessible over the network==
	If you haven't already done so, you will need to make your media files accessible to all your Kodi devices by sharing them on the network through file sharing. Kodi itself or the MySQL server will not share the actual files for this setup. Most operating systems have built-in methods for sharing files to the network, or a [[NAS]] device can be used.		If you haven't already done so, you will need to make your media files accessible to all your Kodi devices by sharing them on the network through file sharing. Kodi itself or the MySQL server will not share the actual files for this setup. Most operating systems have built-in methods for sharing files to the network, or a NAS device can be used.

Karellen at 05:49, 8 July 2020

2020-07-08T05:49:53Z

← Older revision		Revision as of 05:49, 8 July 2020
Line 16:		Line 16:


	See [[:Category:File ~~Sharing~~]] for some of the file sharing methods that work with Kodi.		See [[:Category:File sharing]] for some of the file sharing methods that work with Kodi.

	==Exporting==		==Exporting==
Line 69:		Line 69:
	##Replace the two instances of <code>*...*</code> with local network IP address of your MySQL server. If you installed MySQL on a Windows machine, do not use its NetBIOS name, as not all devices may be able to resolve them.		##Replace the two instances of <code>*...*</code> with local network IP address of your MySQL server. If you installed MySQL on a Windows machine, do not use its NetBIOS name, as not all devices may be able to resolve them.
	##Save the file as '''advancedsettings.xml'''		##Save the file as '''advancedsettings.xml'''
	#Copy this ''advancedsettings.xml'' file you just created to the '''[[~~userdata folder~~]]''' of every Kodi install you want to sync with.		#Copy this ''advancedsettings.xml'' file you just created to the '''[[Userdata]]''' of every Kodi install you want to sync with.
	{{-}}		{{-}}

Line 75:		Line 75:

	==Importing==		==Importing==
	At this point Kodi is using the MySQL server for the database, which means it has a new blank library. Now we can either import an old library (see below) or simply start a new library (see [[~~adding videos to the library~~]]). From this point on, Kodi behaves exactly like it would as if it had a local database, except that database is on the MySQL server and multiple installs can access that single database.		At this point Kodi is using the MySQL server for the database, which means it has a new blank library. Now we can either import an old library (see below) or simply start a new library (see [[HOW-TO:Create_Video_Library]]). From this point on, Kodi behaves exactly like it would as if it had a local database, except that database is on the MySQL server and multiple installs can access that single database.


	# Open any of your installs and re-import your library data, ''or'' simply set up a new library if you are starting fresh.		# Open any of your installs and re-import your library data, ''or'' simply set up a new library if you are starting fresh.
	# Add (or just "set content" on) the networked video source to Kodi and scan it in as if you were setting up your library for the first time (see [[adding videos to the library]]). However, Kodi will read the exported nfo files and images and use those instead of rebuilding the library from scratch. The end result will be an identical library, and your watched status for videos will be preserved.		# Add (or just "set content" on) the networked video source to Kodi and scan it in as if you were setting up your library for the first time (see [[HOW-TO:Create_Video_Library\|adding videos to the library]]). However, Kodi will read the exported nfo files and images and use those instead of rebuilding the library from scratch. The end result will be an identical library, and your watched status for videos will be preserved.
	#:{{Note\|You must add a network source using Kodi's standard formatting. For example, use "smb://192.168.1.20/Videos/" and not "\\BOBPC\Videos\". Try to use static IP addresses over NetBIOS names if using SMB.}}		#:{{Note\|You must add a network source using Kodi's standard formatting. For example, use "smb://192.168.1.20/Videos/" and not "\\BOBPC\Videos\". Try to use static IP addresses over NetBIOS names if using SMB.}}
	# Import the Music Library by doing the following: Same idea as videos, but using the steps for [[adding music to the library]]. You'll end up with an identical library.		# Import the Music Library by doing the following: Same idea as videos, but using the steps for [[HOW-TO:Create_Music_Library\|adding music to the library]]. You'll end up with an identical library.
	You can now add files and update the library from any of your devices and the library for all of them will stay in sync.		You can now add files and update the library from any of your devices and the library for all of them will stay in sync.

Line 97:		Line 97:
	You don't need to do any of the other steps, such as rescanning or reimporting. Any fanart not already cached will be downloaded shortly after. If this method works on one device, it should work on all of them, as they are basically sharing the same "brain" for the video/music metadata.		You don't need to do any of the other steps, such as rescanning or reimporting. Any fanart not already cached will be downloaded shortly after. If this method works on one device, it should work on all of them, as they are basically sharing the same "brain" for the video/music metadata.

	If you however used a metadata collector add-on ([[scraper]]) that does not ship by default with new installations, such as the [[Add-on:Universal Movie Scraper\|Universal Movie Scraper]] you will not be able to display the [[Basic_controls\|media information screen]] on the new Kodi device. To fix that, you need to install the same metadata collector add-on on the new device.		If you however used a metadata collector add-on ([[Scrapers\|scraper]]) that does not ship by default with new installations, such as the [[Add-on:Universal Movie Scraper\|Universal Movie Scraper]] you will not be able to display the [[Basic_controls\|media information screen]] on the new Kodi device. To fix that, you need to install the same metadata collector add-on on the new device.

	==Name tag==		==Name tag==

Karellen at 21:12, 21 May 2020

2020-05-21T21:12:08Z

← Older revision		Revision as of 21:12, 21 May 2020
Line 23:		Line 23:
	{{note\|You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in Kodi.}}		{{note\|You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in Kodi.}}

	{{redv\|'''Warning:''' \|This will create individual ".nfo" and image files along side your video files. This is considered the safest way to backup and/or migrate a library (MySQL or otherwise), but some users might not want the file clutter. ~~For an alternative method see '''[[why multiple files\|here]]'''.}}~~		{{redv\|'''Warning:''' \|This will create individual ".nfo" and image files along side your video files. This is considered the safest way to backup and/or migrate a library (MySQL or otherwise), but some users might not want the file clutter.

	#Open Kodi on the computer that has the library you want to share		#Open Kodi on the computer that has the library you want to share

Karellen: /* Exporting */

2020-02-16T02:57:16Z

Exporting

← Older revision		Revision as of 02:57, 16 February 2020
Line 19:		Line 19:

	==Exporting==		==Exporting==
	{{see also\|~~HOW-TO:~~Backup ~~the video library~~\|Import-export library}}		{{see also\|Backup\|Import-export library}}

	{{note\|You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in Kodi.}}		{{note\|You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in Kodi.}}

Kibje: syntaxhighlighter fix

2018-07-10T12:24:56Z

syntaxhighlighter fix

← Older revision		Revision as of 12:24, 10 July 2018
Line 40:		Line 40:
	\|-		\|-
	\|		\|
	<syntaxhighlight lang=~~"XML"~~>		<syntaxhighlight lang=xml>
	<advancedsettings>		<advancedsettings>
	<videodatabase>		<videodatabase>

Klojum at 11:45, 23 April 2018

2018-04-23T11:45:12Z

← Older revision		Revision as of 11:45, 23 April 2018
Line 107:		Line 107:
	{{note\|Don't try to merge the video and music databases! You need to use different values in the <code><name></code> tag or you'll end up confusing Kodi leading to the library functionality not working at all. In other words, don't use <code><name>Kids</name></code> for both music and videos, but instead use something like <code><name>Kids-music</name></code> and <code><name>Kids-video</name></code>.}}		{{note\|Don't try to merge the video and music databases! You need to use different values in the <code><name></code> tag or you'll end up confusing Kodi leading to the library functionality not working at all. In other words, don't use <code><name>Kids</name></code> for both music and videos, but instead use something like <code><name>Kids-music</name></code> and <code><name>Kids-video</name></code>.}}

	{{~~Isengard~~ updated}}		{{Krypton updated}}

Klojum: /* Exporting */

2018-04-23T11:44:27Z

Exporting

← Older revision		Revision as of 11:44, 23 April 2018
Line 27:		Line 27:
	#Open Kodi on the computer that has the library you want to share		#Open Kodi on the computer that has the library you want to share
	##Export the Video Library by doing the following:		##Export the Video Library by doing the following:
	###Go to '''~~System~~/~~Settings ->~~ Video -> Library''' and select '''Export library'''		###Go to '''Settings/Media/Library/Video Library''' and select '''Export library'''
	###Select '''Multiple files'''		###Select '''Multiple files'''


	##Export the Music Library by doing the following:		##Export the Music Library by doing the following:
	###Go to '''~~System~~/~~Settings ->~~ Music -> Library''' and select '''Export library'''		###Go to ''''Settings/Media/Library/Music Library''' and select '''Export library'''
	###Select '''Multiple files'''		###Select '''Multiple files'''

Klojum: /* Adding new Kodi devices to the MySQL setup */

2018-04-23T11:29:07Z

Adding new Kodi devices to the MySQL setup

← Older revision		Revision as of 11:29, 23 April 2018
Line 83:		Line 83:

	== Adding new Kodi devices to the MySQL setup ==		== Adding new Kodi devices to the MySQL setup ==
	Since the database has now been set up on the MySQL server, all you need to do for any additional devices is ~~add~~ the advancedsettings.xml file. ~~You don't need to do any of~~ the ~~other steps~~, such as ~~rescanning or reimporting~~. ~~If it works on one device then it should work on all of them~~, ~~as they are basically sharing the same~~ "~~brain~~".		Since the database has now been set up on the MySQL server, all you need to do for any additional Kodi devices, is to copy a small number of files/folders.
			* Copy the MySQL connections section for video and/or music databases into the '''advancedsettings.xml''' file on the other Kodi client(s). If you have identical Kodi devices, simply copy the whole advancedsettings.xml file from the initially setup Kodi device.
			* Copy from the same userdata root folder the files, such as "'''favourites.xml'''", "'''sources.xml'''", "'''mediasources.xml'''", "'''passwords.xml'''" (if present).

	If you however used a metadata collector add-on ([[scraper]]) that does not ship by default with new installations, such as the [[Add-on:Universal Movie Scraper\|Universal Movie Scraper]] you will not be able to display the [[Basic_controls\|media information screen]] on the new Kodi device. To fix that you need to install the same metadata collector add-on on the new device.
			To have the other Kodi client(s) also benefit from the already downloaded/cached art thumbnails:
			* Copy the '''Textures13.db''' file from the '''userdata/Database folder''' to the other Kodi client(s).
			* Copy the full '''Thumbnails''' subfolder from the userdata folder to other Kodi client(s). (This subfolder may contain several megabytes of small files when dealing with large video/music collections)


			You don't need to do any of the other steps, such as rescanning or reimporting. Any fanart not already cached will be downloaded shortly after. If this method works on one device, it should work on all of them, as they are basically sharing the same "brain" for the video/music metadata.

			If you however used a metadata collector add-on ([[scraper]]) that does not ship by default with new installations, such as the [[Add-on:Universal Movie Scraper\|Universal Movie Scraper]] you will not be able to display the [[Basic_controls\|media information screen]] on the new Kodi device. To fix that, you need to install the same metadata collector add-on on the new device.

	==Name tag==		==Name tag==

Karellen at 08:36, 5 March 2018

2018-03-05T08:36:14Z

← Older revision		Revision as of 08:36, 5 March 2018
Line 85:		Line 85:
	Since the database has now been set up on the MySQL server, all you need to do for any additional devices is add the advancedsettings.xml file. You don't need to do any of the other steps, such as rescanning or reimporting. If it works on one device then it should work on all of them, as they are basically sharing the same "brain".		Since the database has now been set up on the MySQL server, all you need to do for any additional devices is add the advancedsettings.xml file. You don't need to do any of the other steps, such as rescanning or reimporting. If it works on one device then it should work on all of them, as they are basically sharing the same "brain".

	If you however used a metadata collector add-on ([[scraper]]) that does not ship by default with new installations, such as the [[Add-on:Universal Movie Scraper\|Universal Movie Scraper]] you will not be able to display the [[~~Video_navigation#Media_information_screen~~\|media information screen]] on the new Kodi device. To fix that you need to install the same metadata collector add-on on the new device.		If you however used a metadata collector add-on ([[scraper]]) that does not ship by default with new installations, such as the [[Add-on:Universal Movie Scraper\|Universal Movie Scraper]] you will not be able to display the [[Basic_controls\|media information screen]] on the new Kodi device. To fix that you need to install the same metadata collector add-on on the new device.

	==Name tag==		==Name tag==