MySQL/Upgrading - Revision history

Klojum: /* Making sure Kodi can update the library */

2022-01-23T05:06:29Z

Making sure Kodi can update the library

← Older revision		Revision as of 05:06, 23 January 2022
Line 29:		Line 29:
	For Kodi to update the library from a previous version, you may need to make changes to your MySQL server. The user made for the MySQL DB ("xbmc" in most guides) will need access to create new databases. If the user already has that access then you don't need to do anything. If not, you will have to use the following command on your MySQL server:		For Kodi to update the library from a previous version, you may need to make changes to your MySQL server. The user made for the MySQL DB ("xbmc" in most guides) will need access to create new databases. If the user already has that access then you don't need to do anything. If not, you will have to use the following command on your MySQL server:

	:<~~code~~>GRANT ALL ON . TO 'kodi';</~~code>~~		<syntaxhighlight lang="sql" inline>GRANT ALL ON . TO 'kodi';</syntaxhighlight>

	~~Or if using an old xbmc username:~~

	~~:<code>GRANT ALL ON . TO 'xbmc';</code~~>

Klojum: /* Different Kodi versions */

2022-01-23T04:55:21Z

Different Kodi versions

← Older revision		Revision as of 04:55, 23 January 2022
Line 73:		Line 73:

	===Different Kodi versions===		===Different Kodi versions===
	Using MySQL to sync the library only works if all Kodi devices are using the same version of Kodi.		Using MySQL/MariaDB to sync the video and/or music library only works when all connected Kodi devices are using the same major version of the Kodi application.

	==Notes==		==Notes==

Karellen at 10:36, 12 July 2020

2020-07-12T10:36:27Z

← Older revision		Revision as of 10:36, 12 July 2020
Line 19:		Line 19:


	To backup simply '''''[[Import-export_library\|export]]''''' the library using {{highlight\|bordered=yes\|[[Settings/Media/Library\|Settings -> Media -> Library]]}}. Be aware of the differences between Single File and Separate File exports. For more information see '''[[~~HOW-TO:~~Backup ~~the library~~]]'''.		To backup simply '''''[[Import-export_library\|export]]''''' the library using {{highlight\|bordered=yes\|[[Settings/Media/Library\|Settings -> Media -> Library]]}}. Be aware of the differences between Single File and Separate File exports. For more information see '''[[Backup]]'''.

	==Making sure Kodi can update the library==		==Making sure Kodi can update the library==

Karellen: Fixed outdated links

2018-06-10T00:16:04Z

Fixed outdated links

← Older revision		Revision as of 00:16, 10 June 2018
Line 13:		Line 13:
	{{big\|'''BACKUP YOUR DATABASE JUST IN CASE.'''}}		{{big\|'''BACKUP YOUR DATABASE JUST IN CASE.'''}}

	Even though Kodi makes a copy of your DB and updates that, it is still highly recommended to [[Import - ~~Export Video Library#Import .2F Export options~~\|export]] your library from your current version before beginning the upgrade process. You don't want to find yourself starting your library from scratch, and it's better to be safe than sorry.		Even though Kodi makes a copy of your DB and updates that, it is still highly recommended to '''''[[Import-export_library\|export]]''''' your library from your current version before beginning the upgrade process. You don't want to find yourself starting your library from scratch, and it's better to be safe than sorry.


Line 19:		Line 19:


	To backup simply [[export]] the library ~~to a single file~~ using {{highlight\|bordered=yes\|[[Settings/~~Videos#~~Library\|Settings -> ~~Videos~~ -> Library]] ~~-> Export library~~}} ~~and select "multiple files"~~. "Single ~~file" also works, but "multiple files" is recommended as it is the most fail-safe method, especially for saving/resorting images~~. For more information see '''[[HOW-TO:Backup the library]]'''.		To backup simply '''''[[Import-export_library\|export]]''''' the library using {{highlight\|bordered=yes\|[[Settings/Media/Library\|Settings -> Media -> Library]]}}. Be aware of the differences between Single File and Separate File exports. For more information see '''[[HOW-TO:Backup the library]]'''.

	==Making sure Kodi can update the library==		==Making sure Kodi can update the library==
Line 46:		Line 46:
	# Place between the {{highlight\|<nowiki><videolibrary>...</videolibrary></nowiki>}} tags, both {{highlight\|<nowiki><importwatchedstate>true</importwatchedstate></nowiki>}} and {{highlight\|<nowiki><importresumepoint>true</importresumepoint></nowiki>}}, in your [[advancedsettings.xml]] file on the downgraded Kodi device.		# Place between the {{highlight\|<nowiki><videolibrary>...</videolibrary></nowiki>}} tags, both {{highlight\|<nowiki><importwatchedstate>true</importwatchedstate></nowiki>}} and {{highlight\|<nowiki><importresumepoint>true</importresumepoint></nowiki>}}, in your [[advancedsettings.xml]] file on the downgraded Kodi device.
	# Start Kodi		# Start Kodi
	# [[Export]] the ~~library~~ using {{highlight\|bordered=yes\|[[Settings/~~Videos#~~Library\|Settings -> ~~Videos~~ -> Library]] ~~-> Export library~~}} and select "Separate Files per entry" to export to separate .nfo files next to your video files.		# '''''[[Import-export_library\|Export]]''''' the libraries using {{highlight\|bordered=yes\|[[Settings/Media/Library\|Settings -> Media -> Library]]}} and select "Separate Files per entry" to export to separate .nfo files next to your video files.
	# Select "Export thumbnails and fanart" if you want to save/store such artwork too, next to your video files.		# Select "Export thumbnails and fanart" if you want to save/store such artwork too, next to your video files.
	# Select "Overwrite old files" so video media details, watched status and/or resume points will be updated too.		# Select "Overwrite old files" so video media details, watched status and/or resume points will be updated too.

Karellen at 10:19, 28 February 2018

2018-02-28T10:19:55Z

← Older revision		Revision as of 10:19, 28 February 2018
Line 65:		Line 65:
	# Quit Kodi		# Quit Kodi
	# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).		# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).
	## Consult the table on '''[[~~Database_versions~~]]''' and note the version number for the downgraded version. You will want to get rid of all of the versions '''after''' that version.		## Consult the table on '''[[Databases#Database_Versions]]''' and note the version number for the downgraded version. You will want to get rid of all of the versions '''after''' that version.
	## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases (''after'' the stable version from step 2) called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.		## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases (''after'' the stable version from step 2) called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.
	## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list, ''after'' the stable version from step 2, starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per Kodi version, and do not forget the trailing semicolon.		## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list, ''after'' the stable version from step 2, starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per Kodi version, and do not forget the trailing semicolon.

Karellen at 10:25, 26 February 2018

2018-02-26T10:25:04Z

← Older revision		Revision as of 10:25, 26 February 2018
Line 65:		Line 65:
	# Quit Kodi		# Quit Kodi
	# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).		# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).
	## Consult the table on '''[[~~Databases/Versions~~]]''' and note the version number for the downgraded version. You will want to get rid of all of the versions '''after''' that version.		## Consult the table on '''[[Database_versions]]''' and note the version number for the downgraded version. You will want to get rid of all of the versions '''after''' that version.
	## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases (''after'' the stable version from step 2) called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.		## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases (''after'' the stable version from step 2) called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.
	## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list, ''after'' the stable version from step 2, starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per Kodi version, and do not forget the trailing semicolon.		## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list, ''after'' the stable version from step 2, starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per Kodi version, and do not forget the trailing semicolon.

Ned Scott at 03:53, 25 February 2016

2016-02-25T03:53:44Z

← Older revision		Revision as of 03:53, 25 February 2016
Line 1:		Line 1:
	{{mininav\| [[MySQL]] }}		{{mininav\| [[MySQL]] }}

			{{warning\|MariaDB 10.1.11 users might want to avoid upgrading to Kodi v16 until they have updated MairaDB to 10.1.12.}}
	{{:MySQL/Contents}}		{{:MySQL/Contents}}

Klojum: /* Upgrade fails */

2015-06-20T09:15:05Z

Upgrade fails

← Older revision		Revision as of 09:15, 20 June 2015
Line 40:		Line 40:
	;Method 1		;Method 1

	# Downgrade Kodi on one of your Kodi devices to the previous version of Kodi (you only need to do this to one device). [[Export]] the library ~~to multiple files~~ using {{highlight\|bordered=yes\|[[Settings/Videos#Library\|Settings -> Videos -> Library]] -> Export library}} and select "~~multiple~~ files".		# Downgrade Kodi on one of your Kodi devices to the previous version of Kodi (you only need to do this to one device).
	#~~:'''''Note:''' If~~ you ~~backed up~~ your Kodi ~~database, you can use that backup in place of this first step~~.''		# Quit Kodi
			# Place between the {{highlight\|<nowiki><videolibrary>...</videolibrary></nowiki>}} tags, both {{highlight\|<nowiki><importwatchedstate>true</importwatchedstate></nowiki>}} and {{highlight\|<nowiki><importresumepoint>true</importresumepoint></nowiki>}}, in your [[advancedsettings.xml]] file on the downgraded Kodi device.
			# Start Kodi
			# [[Export]] the library using {{highlight\|bordered=yes\|[[Settings/Videos#Library\|Settings -> Videos -> Library]] -> Export library}} and select "Separate Files per entry" to export to separate .nfo files next to your video files.
			# Select "Export thumbnails and fanart" if you want to save/store such artwork too, next to your video files.
			# Select "Overwrite old files" so video media details, watched status and/or resume points will be updated too.
			# Let Kodi export the video library.
	# Quit Kodi		# Quit Kodi
	~~# Place {{highlight\|<nowiki><importwatchedstate>true</importwatchedstate></nowiki>}} in your [[advancedsettings.xml]] file on the downgraded Kodi device.~~
	# If you used the <name> tag in your [[advancedsettings.xml]] file, remove these lines. Kodi will simply use default database names instead (MyVideos and MyMusic). Sometimes using the <name> tag will cause issues when updating the MySQL libraries, but the tag is not needed as of Kodi v11 and later.		# If you used the <name> tag in your [[advancedsettings.xml]] file, remove these lines. Kodi will simply use default database names instead (MyVideos and MyMusic). Sometimes using the <name> tag will cause issues when updating the MySQL libraries, but the tag is not needed as of Kodi v11 and later.
	# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).		# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).

Ned Scott at 03:03, 12 May 2015

2015-05-12T03:03:40Z

← Older revision		Revision as of 03:03, 12 May 2015
Line 2:		Line 2:
	{{:MySQL/Contents}}		{{:MySQL/Contents}}

	When updating to a new version, ~~{{kodi}}~~ will make a copy of the current DB and upgrade the copy. That way if anything goes wrong in the upgrading you still have an original untouched copy of your DB.		When updating to a new version, Kodi will make a copy of the current DB and upgrade the copy. That way if anything goes wrong in the upgrading you still have an original untouched copy of your DB.


	{{big\|{{note\|Updating your library may take a few minutes, so be sure to give ~~{{kodi}}~~ time to do its thing. Stopping midway will mess up the updated DB. }} }}		{{big\|{{note\|Updating your library may take a few minutes, so be sure to give Kodi time to do its thing. Stopping midway will mess up the updated DB. }} }}


Line 11:		Line 11:
	{{big\|'''BACKUP YOUR DATABASE JUST IN CASE.'''}}		{{big\|'''BACKUP YOUR DATABASE JUST IN CASE.'''}}

	Even though ~~{{kodi}}~~ makes a copy of your DB and updates that, it is still highly recommended to [[Import - Export Video Library#Import .2F Export options\|export]] your library from your current version before beginning the upgrade process. You don't want to find yourself starting your library from scratch, and it's better to be safe than sorry.		Even though Kodi makes a copy of your DB and updates that, it is still highly recommended to [[Import - Export Video Library#Import .2F Export options\|export]] your library from your current version before beginning the upgrade process. You don't want to find yourself starting your library from scratch, and it's better to be safe than sorry.


Line 19:		Line 19:
	To backup simply [[export]] the library to a single file using {{highlight\|bordered=yes\|[[Settings/Videos#Library\|Settings -> Videos -> Library]] -> Export library}} and select "multiple files". "Single file" also works, but "multiple files" is recommended as it is the most fail-safe method, especially for saving/resorting images. For more information see '''[[HOW-TO:Backup the library]]'''.		To backup simply [[export]] the library to a single file using {{highlight\|bordered=yes\|[[Settings/Videos#Library\|Settings -> Videos -> Library]] -> Export library}} and select "multiple files". "Single file" also works, but "multiple files" is recommended as it is the most fail-safe method, especially for saving/resorting images. For more information see '''[[HOW-TO:Backup the library]]'''.

	==Making sure ~~{{kodi}}~~ can update the library==		==Making sure Kodi can update the library==
	{{Note\|If you originally set up MySQL using this ~~{{kodi}}~~ Wiki guide then you should not have to worry about this section. It never hurts to double check the settings, though.}}		{{Note\|If you originally set up MySQL using this Kodi Wiki guide then you should not have to worry about this section. It never hurts to double check the settings, though.}}


	{{Note\|if you used 'xbmc' as a username in the past, you can keep using it even though the program has changed names to Kodi. It makes no difference as long as that is the name you set up MySQL with.}}		{{Note\|if you used 'xbmc' as a username in the past, you can keep using it even though the program has changed names to Kodi. It makes no difference as long as that is the name you set up MySQL with.}}

	For ~~{{kodi}}~~ to update the library from a previous version, you may need to make changes to your MySQL server. The user made for the MySQL DB ("xbmc" in most guides) will need access to create new databases. If the user already has that access then you don't need to do anything. If not, you will have to use the following command on your MySQL server:		For Kodi to update the library from a previous version, you may need to make changes to your MySQL server. The user made for the MySQL DB ("xbmc" in most guides) will need access to create new databases. If the user already has that access then you don't need to do anything. If not, you will have to use the following command on your MySQL server:

	:<code>GRANT ALL ON . TO 'kodi';</code>		:<code>GRANT ALL ON . TO 'kodi';</code>
Line 34:		Line 34:


	If you are worried about security then you can limit Kodi's access in MySQL once it has created the new video DB. However, you will need to re-grant these privileges the next time you update Kodi. If the only thing you use MySQL for is ~~{{kodi}}~~ then you don't really need to worry about security.		If you are worried about security then you can limit Kodi's access in MySQL once it has created the new video DB. However, you will need to re-grant these privileges the next time you update Kodi. If the only thing you use MySQL for is Kodi then you don't really need to worry about security.

	==Common problems==		==Common problems==
Line 40:		Line 40:
	;Method 1		;Method 1

	# Downgrade ~~{{kodi}}~~ on one of your ~~{{kodi}}~~ devices to the previous version of ~~{{kodi}}~~ (you only need to do this to one device). [[Export]] the library to multiple files using {{highlight\|bordered=yes\|[[Settings/Videos#Library\|Settings -> Videos -> Library]] -> Export library}} and select "multiple files".		# Downgrade Kodi on one of your Kodi devices to the previous version of Kodi (you only need to do this to one device). [[Export]] the library to multiple files using {{highlight\|bordered=yes\|[[Settings/Videos#Library\|Settings -> Videos -> Library]] -> Export library}} and select "multiple files".
	#:'''''Note:''' If you backed up your ~~{{kodi}}~~ database, you can use that backup in place of this first step.''		#:'''''Note:''' If you backed up your Kodi database, you can use that backup in place of this first step.''
	# Quit Kodi		# Quit Kodi
	# Place {{highlight\|<nowiki><importwatchedstate>true</importwatchedstate></nowiki>}} in your [[advancedsettings.xml]] file on the downgraded ~~{{kodi}}~~ device.		# Place {{highlight\|<nowiki><importwatchedstate>true</importwatchedstate></nowiki>}} in your [[advancedsettings.xml]] file on the downgraded Kodi device.
	# If you used the <name> tag in your [[advancedsettings.xml]] file, remove these lines. ~~{{kodi}}~~ will simply use default database names instead (MyVideos and MyMusic). Sometimes using the <name> tag will cause issues when updating the MySQL libraries, but the tag is not needed as of ~~{{kodi}}~~ v11 and later.		# If you used the <name> tag in your [[advancedsettings.xml]] file, remove these lines. Kodi will simply use default database names instead (MyVideos and MyMusic). Sometimes using the <name> tag will cause issues when updating the MySQL libraries, but the tag is not needed as of Kodi v11 and later.
	# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the ~~{{kodi}}~~ database(s).		# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).
	## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.		## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.
	## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per ~~{{kodi}}~~ version, and do not forget the trailing semicolon.		## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per Kodi version, and do not forget the trailing semicolon.
	# You can now re-update the device you downgraded in step 1.		# You can now re-update the device you downgraded in step 1.
	# Import the library by simply scanning it in as a new file source. ~~{{kodi}}~~ will pick up the exported data as it scans the files in.		# Import the library by simply scanning it in as a new file source. Kodi will pick up the exported data as it scans the files in.
	# ~~{{kodi}}~~ will now rebuild a fresh MySQL library DB, but using all your existing information.		# Kodi will now rebuild a fresh MySQL library DB, but using all your existing information.
	# You can now open/launch ~~{{kodi}}~~ on the other devices.		# You can now open/launch Kodi on the other devices.


Line 57:		Line 57:

	# Quit Kodi		# Quit Kodi
	# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the ~~{{kodi}}~~ database(s).		# Use the MySQL configuration utility to drop/delete the existing MySQL copies of the Kodi database(s).
	## Consult the table on '''[[Databases/Versions]]''' and note the version number for the downgraded version. You will want to get rid of all of the versions '''after''' that version.		## Consult the table on '''[[Databases/Versions]]''' and note the version number for the downgraded version. You will want to get rid of all of the versions '''after''' that version.
	## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases (''after'' the stable version from step 2) called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.		## When using phpMyAdmin: select ''Databases'' option from the top of the screen, put a checkbox in front of all databases (''after'' the stable version from step 2) called '''MyMusic''' or '''MyVideos''' followed by some digits, and select ''Drop'' underneath the list. Confirm that you want to drop the databases.
	## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list, ''after'' the stable version from step 2, starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per ~~{{kodi}}~~ version, and do not forget the trailing semicolon.		## When using the command line tools: enter <code>show databases;</code> including the semicolon. Type <code>drop database <name>;</code> for every name in the resulting list, ''after'' the stable version from step 2, starting with '''MyMusic''' or '''MyVideos''' and followed by some digits, for example: <code>drop database MyVideos78; drop database MyMusic46;</code> Note that actual names may vary per Kodi version, and do not forget the trailing semicolon.
	# Start one ~~{{kodi}}~~ instance that is using the version you want to use and give it lots of time to update the database.		# Start one Kodi instance that is using the version you want to use and give it lots of time to update the database.
	# ~~{{kodi}}~~ will make a new updated DB using the last working DB from the previous ~~{{kodi}}~~ installation.		# Kodi will make a new updated DB using the last working DB from the previous Kodi installation.
	# You can now open/launch ~~{{kodi}}~~ on the other devices.		# You can now open/launch Kodi on the other devices.

	===Different ~~{{kodi}}~~ versions===		===Different Kodi versions===
	Using MySQL to sync the library only works if all ~~{{kodi}}~~ devices are using the same version of Kodi.		Using MySQL to sync the library only works if all Kodi devices are using the same version of Kodi.

	==Notes==		==Notes==
	<references />		<references />

	{{~~Helix~~ updated}}		{{Isengard updated}}

Ned Scott at 05:07, 9 March 2015

2015-03-09T05:07:23Z

← Older revision		Revision as of 05:07, 9 March 2015
Line 1:		Line 1:

	{{mininav\| [[MySQL]] }}		{{mininav\| [[MySQL]] }}
	~~{{Kodi MySQL}}~~
	{{:MySQL/Contents}}		{{:MySQL/Contents}}