HOW-TO:Update Paths In MySQL - Revision history

Klojum: /* Method 1 */

2019-12-12T07:13:53Z

Method 1

← Older revision		Revision as of 07:13, 12 December 2019
Line 35:		Line 35:

	Now just start creating your new sql query...		Now just start creating your new sql query...
	ex: '''~~update~~ art ~~set~~ url = replace(url,'smb://fn1/','smb://galaxy.local/media/');'''		ex: '''UPDATE art SET url = replace(url,'smb://fn1/','smb://galaxy.local/media/');'''

	Then just do that for every table you see in those results that need it.		Then just do that for every table you see in those results that need it.

Klojum: /* Example */

2019-12-12T07:12:34Z

Example

← Older revision		Revision as of 07:12, 12 December 2019
Line 234:		Line 234:

	<pre>		<pre>
	~~update movieview set strFileName = replace(strFileName,'smb://movies1/share/','smb://big_movie_nas/');~~		UPDATE movie SET c22 = replace(c22,'smb://movies1/share/','smb://big_movie_nas/');
	~~update movieview set strFileName = replace(strFileName,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');~~		UPDATE movie SET c22 = replace(c22,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');
	~~update movieview set c19 = replace(c19,'smb://movies1/share/','smb://big_movie_nas/');~~
	~~update movieview set c19 = replace(c19,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');~~
	~~update movieview set~~ c22 = replace(c22,'smb://movies1/share/','smb://big_movie_nas/');
	~~update movieview set~~ c22 = replace(c22,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');
	</pre>		</pre>

Klojum: /* Example */

2019-12-12T07:08:30Z

Example

← Older revision		Revision as of 07:08, 12 December 2019
Line 164:		Line 164:

	<pre>		<pre>
	~~update~~ path ~~set~~ strPath = replace(strPath,'smb://movie_nas/share/','smb://bigger_movies/');		UPDATE path SET strPath = replace(strPath,'smb://movie_nas/share/','smb://bigger_movies/');
	~~update~~ path ~~set~~ strPath = replace(strPath,'smb://tv_nas/tv/share/','smb://bigger_tv/');		UPDATE path SET strPath = replace(strPath,'smb://tv_nas/tv/share/','smb://bigger_tv/');
	</pre>		</pre>

Klojum: /* Example */

2019-12-12T07:07:57Z

Example

← Older revision		Revision as of 07:07, 12 December 2019
Line 267:		Line 267:

	<pre>		<pre>
	~~update~~ movie ~~set~~ c19 = replace(c19,'smb://movies1/share/','smb://big_movie_nas/');		UPDATE movie SET c19 = replace(c19,'smb://movies1/share/','smb://big_movie_nas/');
	~~update~~ movie ~~set~~ c19 = replace(c19,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');		UPDATE movie SET c19 = replace(c19,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');
	~~update~~ movie ~~set~~ c22 = replace(c22,'smb://movies1/share/','smb://big_movie_nas/');		UPDATE movie SET c22 = replace(c22,'smb://movies1/share/','smb://big_movie_nas/');
	~~update~~ movie ~~set~~ c22 = replace(c22,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');		UPDATE movie SET c22 = replace(c22,'smb://movies2/movies/share/','smb://big_movie_nas/movies/');
	</pre>		</pre>

Klojum: /* Method 1 */

2019-12-12T07:06:33Z

Method 1

← Older revision		Revision as of 07:06, 12 December 2019
Line 37:		Line 37:
	ex: '''update art set url = replace(url,'smb://fn1/','smb://galaxy.local/media/');'''		ex: '''update art set url = replace(url,'smb://fn1/','smb://galaxy.local/media/');'''

	Then just do that for every table you see in those results that need it.~~.. Below are~~ the tables I altered.		Then just do that for every table you see in those results that need it.
			As per MyVideos116, the following tables need to be altered.
	<pre>		<pre>
	~~update path set strPath = replace(strPath,'smb://fn1/','smb://galaxy.local/media/');~~		UPDATE art SET url = replace(strPath,'smb://fn1/','smb://galaxy.local/media/');
	~~update movieview set c22 = replace(c22,'smb://fn1/','smb://galaxy.local/media/');~~		UPDATE episode SET c18 = replace(c18,'smb://fn1/','smb://galaxy.local/media/');
	~~update~~ art ~~set~~ url = replace(~~url~~,'smb://fn1/','smb://galaxy.local/media/');		UPDATE movie SET c22 = replace(c22,'smb://fn1/','smb://galaxy.local/media/');
	~~update~~ episode ~~set~~ c18 = replace(c18,'smb://fn1/','smb://galaxy.local/media/');		UPDATE path SET strPath = replace(strPath,'smb://fn1/','smb://galaxy.local/media/');
	~~update episodeview set c18~~ = replace(~~c18~~,'smb://fn1/','smb://galaxy.local/media/');
	~~update episodeview set strShowPath~~ = replace(~~strShowPath,'smb://fn1/','smb://galaxy.local/media/');~~
	~~update tvshow set c16 = replace(c16~~,'smb://fn1/','smb://galaxy.local/media/');
	</pre>		</pre>

Ned Scott at 08:54, 24 May 2014

2014-05-24T08:54:46Z

← Older revision		Revision as of 08:54, 24 May 2014
Line 1:		Line 1:
	{{:MySQL/Contents}}		{{:MySQL/Contents}}
	{{mininav\| [[MySQL]] }}		{{mininav\| [[MySQL]] }}
			= Method 1 =
	==Easy method to catch ALL instances of the data to change==		==Easy method to catch ALL instances of the data to change==
	2014-05-23 Update! Much easier method to catch ALL instances of the data to change. Below is my example!		2014-05-23 Update! Much easier method to catch ALL instances of the data to change. Below is my example!
Line 47:		Line 48:
	</pre>		</pre>

			= Method 2 =
	==Preamble==		==Preamble==
	This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.		This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.

Arvobowen: Added a way to find ALL occurrences of the old server share and replace it with the new server share.

2014-05-24T03:50:28Z

Added a way to find ALL occurrences of the old server share and replace it with the new server share.

@@ Line 1: / Line 1: @@
 {{:MySQL/Contents}}
 {{mininav| [[MySQL]] }}
 ==Preamble==
 This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.

Ned Scott: /* Backup Sources */ Not sure what sources.xml has to do with updating the MySQL DB

2014-05-19T06:12:59Z

Backup Sources: Not sure what sources.xml has to do with updating the MySQL DB

← Older revision		Revision as of 06:12, 19 May 2014
Line 32:		Line 32:
	Leave HeidiSQL open, we'll come back to it shortly.		Leave HeidiSQL open, we'll come back to it shortly.


	~~==Backup Sources==~~

	~~Make a backup of your [[sources.xml\|http://wiki.xbmc.org/index.php?title=Userdata/sources.xml]]. You can simply copy your sources.xml and paste it in another location for safekeeping.~~

	==Backup Database==		==Backup Database==

Ned Scott at 00:06, 26 April 2014

2014-04-26T00:06:03Z

← Older revision		Revision as of 00:06, 26 April 2014
Line 1:		Line 1:
	{{:MySQL/Contents}}		{{:MySQL/Contents}}
			{{mininav\| [[MySQL]] }}
	==Preamble==		==Preamble==
	This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.		This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.

Ned Scott at 06:44, 21 April 2014

2014-04-21T06:44:36Z

← Older revision		Revision as of 06:44, 21 April 2014
Line 1:		Line 1:
	{{:~~HOW-TO:Sync multiple libraries~~/Contents}}		{{:MySQL/Contents}}
	==Preamble==		==Preamble==
	This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.		This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc. when using a MySQL database. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again.