MySQL/Advanced notes - Revision history

Ksooo at 12:41, 18 April 2025

2025-04-18T12:41:00Z

← Older revision		Revision as of 12:41, 18 April 2025
Line 6:		Line 6:
	For a full listing of the advancedsettings.xml parameters, see '''[[advancedsettings.xml#musicdatabase/videodatabase]]'''		For a full listing of the advancedsettings.xml parameters, see '''[[advancedsettings.xml#musicdatabase/videodatabase]]'''

	== Other databases (PVR ~~and ADSP~~) ==		== Other databases (PVR) ==

	{{MySQL warning}}		{{MySQL warning}}

RogueScholar: Add Next template with link to the next sequentially serialized page on the topic which had be previously orphaned

2022-03-20T12:39:23Z

Add Next template with link to the next sequentially serialized page on the topic which had be previously orphaned

← Older revision		Revision as of 12:39, 20 March 2022
Line 144:		Line 144:
	==Multiple profiles with one MySQL database==		==Multiple profiles with one MySQL database==
	The idea is to share information on files in the library (only scrape once) but have individual watch status for every profile. For information see the forum thread [http://forum.kodi.tv/showthread.php?tid=196821 [MYSQL<nowiki>]</nowiki> HOW-TO: 5 User XBMC] and for a setup for Kodi v16 see [http://forum.kodi.tv/showthread.php?tid=196821&pid=2280431#pid2280431 this post]. An older setup can be found at: http://forum.kodi.tv/showthread.php?tid=81095&pid=840499#pid840499		The idea is to share information on files in the library (only scrape once) but have individual watch status for every profile. For information see the forum thread [http://forum.kodi.tv/showthread.php?tid=196821 [MYSQL<nowiki>]</nowiki> HOW-TO: 5 User XBMC] and for a setup for Kodi v16 see [http://forum.kodi.tv/showthread.php?tid=196821&pid=2280431#pid2280431 this post]. An older setup can be found at: http://forum.kodi.tv/showthread.php?tid=81095&pid=840499#pid840499


			{{Next\|[[MySQL/Backup and restore databases\|Backup and restore databases]]}}

	{{Updated\|16}}		{{Updated\|16}}

Graysky: /* Removing stale entries from the database */ refine wording a bit

2021-02-01T12:00:10Z

Removing stale entries from the database: refine wording a bit

← Older revision		Revision as of 12:00, 1 February 2021
Line 17:		Line 17:

	==Removing stale entries from the database==		==Removing stale entries from the database==
	Occasionally, it can be beneficial to remove database entries ~~corresponding~~ files that are no longer on available on the file-system. ~~Take note~~ that ~~the~~ database entries ~~for such files~~ are ~~separate~~ from the library status which ~~can be~~ managed by Kodi ~~built~~ in ~~actions~~. ~~The database should ALWAYS be backed-up before attempting these commands~~.		Occasionally, it can be beneficial to remove database entries that correspond to files that are no longer on available on the file-system. Note that these orphaned database entries are independent from the Kodi library status which is managed by Kodi [[https://kodi.wiki/view/List_of_built-in_functions#Library_built-in.27s built ins]] such as '''CleanLibrary()'''.

	To ~~clear the~~ database entries, connect to the box serving up the SQL database and log into the SQL database:		{{Warning\|The database should ALWAYS be backed-up before attempting these commands.}}

			To locate and delete orphaned database entries, connect to the box serving up the SQL database and log into the SQL database:
	mysql -u root -p		mysql -u root -p

Graysky: add section to clean stale entries, inspiration from forum post: https://forum.kodi.tv/showthread.php?tid=294011&pid=3010780#pid3010780

2021-02-01T02:10:29Z

add section to clean stale entries, inspiration from forum post: https://forum.kodi.tv/showthread.php?tid=294011&pid=3010780#pid3010780

@@ Line 15: / Line 15: @@
 Use the IP address and NOT the hostname of your MySQL server<br />
 eg.: 192.168.1.105 <<IP address>> instead of \\SERVER
 === In my.cnf (my.ini for older versions): ===

Yol: Remove outdated info

2019-01-21T08:20:28Z

Remove outdated info

← Older revision		Revision as of 08:20, 21 January 2019
Line 11:		Line 11:

	==MySQL speed-up tweaks==		==MySQL speed-up tweaks==
	~~For Kodi/XBMC ≤ v12 (Frodo) and/or MySQL 5.0 or lower: with MyISAM as the default storage engine, the following tweaks are necessary:<br />~~
	~~[http://xbmcstuff.bossanova808.net/2011/03/summary-of-xbmc-mysql-database.html?m=1 MySQL speed-up tweaks for Kodi/XBMC] - See Comments for more information.<br />~~
	~~[http://forum.kodi.tv/showthread.php?tid=212806&pid=1875330#pid1875330 More MySQL speed-up tweaks for Kodi/XBMC]<br />~~
	~~<br />~~
	~~For MySQL 5.5 or latest: with InnoDB as the default storage engine and/or v13 (Gotham)/Kodi+ only the following two tweaks are necessary.~~
	=== In advancedsettings.xml: ===		=== In advancedsettings.xml: ===
	Use the IP address and NOT the hostname of your MySQL server<br />		Use the IP address and NOT the hostname of your MySQL server<br />

Kibje: syntaxhighligher fix

2018-07-10T12:24:35Z

syntaxhighligher fix

← Older revision		Revision as of 12:24, 10 July 2018
Line 46:		Line 46:
	We're going to create a down and dirty batch file to perform the actual backup, then we'll execute the batch script with the task scheduler built into Windows. For the purpose of these instructions, it is assumed that you are running MySQL 5.5 installed to the default location. If not, be sure to adjust your path(s) accordingly. It's also a good idea to save your backups to a network location to protect against local drive failure, so the paths here will reflect this. So here are the batch file contents:		We're going to create a down and dirty batch file to perform the actual backup, then we'll execute the batch script with the task scheduler built into Windows. For the purpose of these instructions, it is assumed that you are running MySQL 5.5 installed to the default location. If not, be sure to adjust your path(s) accordingly. It's also a good idea to save your backups to a network location to protect against local drive failure, so the paths here will reflect this. So here are the batch file contents:

	<syntaxhighlight lang="winbatch" enclose="div">		<syntaxhighlight lang=winbatch enclose="div">
	:: All lines that start with 2 colons are comments, they do not affect the script itself. These comments are explanations of each command, as well as instructions for the things that you will need to edit. Pay close attention to all comments.		:: All lines that start with 2 colons are comments, they do not affect the script itself. These comments are explanations of each command, as well as instructions for the things that you will need to edit. Pay close attention to all comments.

Ned Scott at 15:44, 28 July 2016

2016-07-28T15:44:39Z

← Older revision		Revision as of 15:44, 28 July 2016
Line 128:		Line 128:
	The idea is to share information on files in the library (only scrape once) but have individual watch status for every profile. For information see the forum thread [http://forum.kodi.tv/showthread.php?tid=196821 [MYSQL<nowiki>]</nowiki> HOW-TO: 5 User XBMC] and for a setup for Kodi v16 see [http://forum.kodi.tv/showthread.php?tid=196821&pid=2280431#pid2280431 this post]. An older setup can be found at: http://forum.kodi.tv/showthread.php?tid=81095&pid=840499#pid840499		The idea is to share information on files in the library (only scrape once) but have individual watch status for every profile. For information see the forum thread [http://forum.kodi.tv/showthread.php?tid=196821 [MYSQL<nowiki>]</nowiki> HOW-TO: 5 User XBMC] and for a setup for Kodi v16 see [http://forum.kodi.tv/showthread.php?tid=196821&pid=2280431#pid2280431 this post]. An older setup can be found at: http://forum.kodi.tv/showthread.php?tid=81095&pid=840499#pid840499

	{{~~Isengard updated~~}}		{{Updated\|16}}

Ned Scott: /* advancedsettings.xml */

2016-07-28T15:42:38Z

advancedsettings.xml

← Older revision		Revision as of 15:42, 28 July 2016
Line 4:		Line 4:
	{{-}}		{{-}}
	==advancedsettings.xml==		==advancedsettings.xml==
	For a full listing of the advancedsettings.xml parameters, see '''[[advancedsettings.xml#~~database tags music~~/~~video/tv/epg/adsp~~]]'''		For a full listing of the advancedsettings.xml parameters, see '''[[advancedsettings.xml#musicdatabase/videodatabase]]'''

	== Other databases (PVR and ADSP) ==		== Other databases (PVR and ADSP) ==

Ned Scott: /* Other databases (PVR and ADSP) */

2016-07-28T15:35:47Z

Other databases (PVR and ADSP)

← Older revision		Revision as of 15:35, 28 July 2016
Line 8:		Line 8:
	== Other databases (PVR and ADSP) ==		== Other databases (PVR and ADSP) ==

	{{warning\|Kodi also supports using MySQL for PVR (tvdatabase and epgdatabase) as well as the ADSP database. However, there is little to no real benefit to using MySQL for those databases, and there has been very little testing with them (expect bugs!). Unless you simply want to experiment, or have a very specific need, you should avoid using MySQL for PVR and ADSP.}}		{{MySQL warning}}

	==MySQL speed-up tweaks==		==MySQL speed-up tweaks==

Ned Scott: /* Other databases (PVR and ADSP) */

2016-07-28T15:35:25Z

Other databases (PVR and ADSP)

← Older revision		Revision as of 15:35, 28 July 2016
Line 8:		Line 8:
	== Other databases (PVR and ADSP) ==		== Other databases (PVR and ADSP) ==

	Kodi also supports using MySQL for PVR (tvdatabase and epgdatabase) as well as the ADSP database. However, ~~since so few users have used~~ MySQL for those databases, there ~~may be lots of~~ bugs ~~and issues~~. ~~Feel free~~ to ~~try it out~~ for ~~the two~~ PVR ~~databases, but the~~ ADSP ~~database isn't likely to be practical for most users to share. For more info see '''[[advancedsettings.xml#database tags music/video/tv/epg/adsp\|here]]'''~~.		{{warning\|Kodi also supports using MySQL for PVR (tvdatabase and epgdatabase) as well as the ADSP database. However, there is little to no real benefit to using MySQL for those databases, and there has been very little testing with them (expect bugs!). Unless you simply want to experiment, or have a very specific need, you should avoid using MySQL for PVR and ADSP.}}

	==MySQL speed-up tweaks==		==MySQL speed-up tweaks==