MySQL/Portable devices and profiles - Revision history

Klojum at 10:22, 11 October 2018

2018-10-11T10:22:03Z

← Older revision		Revision as of 10:22, 11 October 2018
Line 78:		Line 78:
	By using the <code><name></code>-tags this advancedsettings.xml file will point to a database with a "Bob" prefix name, instead of the default "myvideos" or "mymusic" prefix (these are used when the name tag is excluded). Other Kodi installations or profiles that use the Bob name will all be pointing to the same MySQL database (assuming all are using the same Kodi version).		By using the <code><name></code>-tags this advancedsettings.xml file will point to a database with a "Bob" prefix name, instead of the default "myvideos" or "mymusic" prefix (these are used when the name tag is excluded). Other Kodi installations or profiles that use the Bob name will all be pointing to the same MySQL database (assuming all are using the same Kodi version).

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

Klojum: /* Portable devices */

2018-10-11T10:21:40Z

Portable devices

← Older revision		Revision as of 10:21, 11 October 2018
Line 8:		Line 8:

	First create two profiles. Configure one profile for "local use" (internal HDD only, while traveling, etc) and another for using a central database. You can even make profiles for different wifi networks that have different centralized databases (your home, a friend's home, etc).		First create two profiles. Configure one profile for "local use" (internal HDD only, while traveling, etc) and another for using a central database. You can even make profiles for different wifi networks that have different centralized databases (your home, a friend's home, etc).

			{{divbox\|red\|\|'''Note:''' Path substition for "sources" and profiles is broken, and will '''NOT''' be fixed.}}

	=== Create profiles ===		=== Create profiles ===
Line 45:		Line 47:

	See [[MySQL/Setting up Kodi\|Setting up Kodi]] for more information.		See [[MySQL/Setting up Kodi\|Setting up Kodi]] for more information.


	== Using different MySQL servers per profile ==		== Using different MySQL servers per profile ==

Ned Scott: /* Using different MySQL servers per profile */

2016-07-19T09:25:26Z

Using different MySQL servers per profile

← Older revision		Revision as of 09:25, 19 July 2016
Line 75:		Line 75:
	</nowiki></pre>		</nowiki></pre>

	~~Using~~ the <code><name></code> tags this advancedsettings.xml file will point to a database with a "Bob" prefix name, instead of the default "myvideos" or "mymusic" prefix (these are used when the name tag is excluded).		By using the <code><name></code>-tags this advancedsettings.xml file will point to a database with a "Bob" prefix name, instead of the default "myvideos" or "mymusic" prefix (these are used when the name tag is excluded). Other Kodi installations or profiles that use the Bob name will all be pointing to the same MySQL database (assuming all are using the same Kodi version).

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

Ned Scott at 09:24, 19 July 2016

2016-07-19T09:24:05Z

← Older revision		Revision as of 09:24, 19 July 2016
Line 1:		Line 1:
	{{:MySQL/Contents}}		{{:MySQL/Contents}}
	{{mininav\| [[MySQL]] }}		{{mininav\| [[MySQL]] }}
			{{see also\|Profiles}}

			== Portable devices ==

	If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.		If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.

	First create two profiles. Configure one profile for "local use" (internal HDD only, while traveling, etc) and another for using a central database. You can even make profiles for different wifi networks that have different centralized databases (your home, a friend's home, etc).		First create two profiles. Configure one profile for "local use" (internal HDD only, while traveling, etc) and another for using a central database. You can even make profiles for different wifi networks that have different centralized databases (your home, a friend's home, etc).

	== Create profiles ==		=== Create profiles ===
	{{main\|Profiles}}		{{main\|Profiles}}
	#Configure the Master User profile:		#Configure the Master User profile:
Line 18:		Line 22:
	# Enable the login screen to select a profile on startup		# Enable the login screen to select a profile on startup

	== Configure the MySQL profile ==		=== Configure the MySQL profile ===
	Create a new file "advancedsettings.xml" in [[userdata]]/profiles/<username>/:		Create a new file "advancedsettings.xml" in [[userdata]]/profiles/<username>/:
	<pre><nowiki>		<pre><nowiki>
Line 48:		Line 52:
	For example:		For example:

			Create a new file "advancedsettings.xml" in [[userdata]]/profiles/<username>/:
	<pre><nowiki>		<pre><nowiki>
	<advancedsettings>		<advancedsettings>

Ned Scott at 09:23, 19 July 2016

2016-07-19T09:23:08Z

← Older revision		Revision as of 09:23, 19 July 2016
Line 43:		Line 43:


	{{~~Isengard updated~~}}		== Using different MySQL servers per profile ==
			Each profile acts as a different set of Kodi settings, and can have their own advancedsettings.xml file. By setting up either different MySQL servers, or a single MySQL server with different database names, each profile can point to a different MySQL library.

			For example:

			<pre><nowiki>
			<advancedsettings>
			<videodatabase>
			<type>mysql</type>
			<host>*...*</host>
			<name>Bob</name>
			<port>3306</port>
			<user>kodi</user>
			<pass>kodi</pass>
			</videodatabase>

			<musicdatabase>
			<type>mysql</type>
			<host>*...*</host>
			<name>Bob</name>
			<port>3306</port>
			<user>kodi</user>
			<pass>kodi</pass>
			</musicdatabase>
			</advancedsettings>
			</nowiki></pre>

			Using the <code><name></code> tags this advancedsettings.xml file will point to a database with a "Bob" prefix name, instead of the default "myvideos" or "mymusic" prefix (these are used when the name tag is excluded).

			{{Updated\|16}}

Ned Scott at 03:04, 12 May 2015

2015-05-12T03:04:56Z

← Older revision		Revision as of 03:04, 12 May 2015
Line 40:		Line 40:
	</nowiki></pre>		</nowiki></pre>

	See [[MySQL/Setting up ~~XBMC~~\|Setting up ~~XMBC~~]] for more information.		See [[MySQL/Setting up Kodi\|Setting up Kodi]] for more information.


	{{~~Gotham~~ updated}}		{{Isengard updated}}

Sharrken: /* Configure the MySQL profile */ {{kodi}} name changes

2015-01-10T22:05:11Z

Configure the MySQL profile: {{kodi}} name changes

← Older revision		Revision as of 22:05, 10 January 2015
Line 26:		Line 26:
	<host>*...*</host>		<host>*...*</host>
	<port>3306</port>		<port>3306</port>
	<user>~~xbmc~~</user>		<user>kodi</user>
	<pass>~~xbmc~~</pass>		<pass>kodi</pass>
	</videodatabase>		</videodatabase>

Line 34:		Line 34:
	<host>*...*</host>		<host>*...*</host>
	<port>3306</port>		<port>3306</port>
	<user>~~xbmc~~</user>		<user>kodi</user>
	<pass>~~xbmc~~</pass>		<pass>kodi</pass>
	</musicdatabase>		</musicdatabase>
	</advancedsettings>		</advancedsettings>

Ned Scott at 08:10, 27 September 2014

2014-09-27T08:10:46Z

← Older revision		Revision as of 08:10, 27 September 2014
Line 43:		Line 43:


	{{~~Frodo~~ updated}}		{{Gotham updated}}

Ned Scott at 00:05, 26 April 2014

2014-04-26T00:05:25Z

← Older revision		Revision as of 00:05, 26 April 2014
Line 1:		Line 1:
	{{:MySQL/Contents}}		{{:MySQL/Contents}}
			{{mininav\| [[MySQL]] }}
	If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.		If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.

Ned Scott at 06:42, 21 April 2014

2014-04-21T06:42:08Z

← Older revision		Revision as of 06:42, 21 April 2014
Line 1:		Line 1:
	~~{{Frodo updated}}~~{{:~~HOW-TO:Sync multiple libraries~~/Contents}}		{{:MySQL/Contents}}

	If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.		If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.
Line 40:		Line 40:
	</nowiki></pre>		</nowiki></pre>

	See [[~~HOW-TO:Sync_multiple_libraries~~/~~Setting_up_XBMC~~\|Setting up XMBC]] for more information.		See [[MySQL/Setting up XBMC\|Setting up XMBC]] for more information.


			{{Frodo updated}}