Shared database for video, music, etc.

rick78 · 2008-03-03, 10:17

Hi All,
There have been a few posts about this in the past, and a server setup may be the way to do it.
However, I would like to hear if there is another possibility.
I have 5 PCs in the house running MP. All have a network share to a NAS, where I have 1 TB of video, music, and pictures.
I would like to be able to have a database folder on the NAS, where all machines could use so that I only have to update it from one machine.
Is this possible?

I have read a post with a work around, where I would copy the database files and the thumbs.
All PCs are using the same drive letter for the mapping (U).
Is this the best work around?

Thanks for any input.

Regards,
Rick

charli181 · 2008-03-03, 13:15

nope, that about it for now. There is a restriction with SQLite databases where only one connection is allowed at a time otherwise the secondary clients receive locked error messages. I was think or writing a plugin for MP 1 where one database was selected as master and would export all information into the TVServer MSSQL/MySQL database, including thumbs. All other machines would be clients and then retrieve from the TV Server DB adn update the local files. There are limitations to this thought and am currently working on it.

Vampiro · 2008-03-03, 16:22

I cmoved all my movies to an external ethernet hard drive. Is it possible to edit the movie database to change the path were my videos are now stored insted of import all ther info again? And how?
Thanks

rick78 · 2008-03-03, 17:04

Good question. I am interested in hearing if it possible edit the data in the database as well.

allanp81 · 2008-03-03, 17:12

No for the reasons specified by charli181. You cannot share the databases between clients apart from having 1 "master" and copying to all other clients.

Vampiro · 2008-03-03, 17:19

I don't want to share the databases, only to change the path inside those databases...

allanp81 · 2008-03-03, 17:26

You need a browser that can view and edit the sqlite database then. Do a quick search in google.

Paranoid Delusion · 2008-03-03, 17:35

Quote:

You need a browser that can view and edit the sqlite database then. Do a quick search in google

Like the one that's in mediaportal\docs folder

rick78 · 2008-03-03, 19:58

Thanks guys.
I found that on Sourceforge. It seems to do the trick.

/Rick

Vampiro · 2008-03-04, 00:01

Quote:

Originally Posted by Paranoid Delusion

Quote:

You need a browser that can view and edit the sqlite database then. Do a quick search in google

Like the one that's in mediaportal\docs folder

humm... can't find it...

2008-03-03, 10:17	#1 (permalink)
rick78 Portal Member Join Date: Feb 2006 Location: Copenhagen, Denmark Age: 41 Posts: 61 Thanks: 6 Thanked 0 Times in 0 Posts Country:	Shared database for video, music, etc. Hi All, There have been a few posts about this in the past, and a server setup may be the way to do it. However, I would like to hear if there is another possibility. I have 5 PCs in the house running MP. All have a network share to a NAS, where I have 1 TB of video, music, and pictures. I would like to be able to have a database folder on the NAS, where all machines could use so that I only have to update it from one machine. Is this possible? I have read a post with a work around, where I would copy the database files and the thumbs. All PCs are using the same drive letter for the mapping (U). Is this the best work around? Thanks for any input. Regards, Rick

2008-03-03, 13:15	#2 (permalink)
charli181 Docs Team Join Date: Aug 2007 Location: Sydney Age: 36 Posts: 673 Thanks: 35 Thanked 37 Times in 30 Posts Country: My System	nope, that about it for now. There is a restriction with SQLite databases where only one connection is allowed at a time otherwise the secondary clients receive locked error messages. I was think or writing a plugin for MP 1 where one database was selected as master and would export all information into the TVServer MSSQL/MySQL database, including thumbs. All other machines would be clients and then retrieve from the TV Server DB adn update the local files. There are limitations to this thought and am currently working on it. __________________ Bubble wrap is the solution to all of life's problems...!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shared view or Database view	Bertuz	General Support	1	2008-01-20 21:11
video & music shared playlist	CHACAL	Listen Music	5	2007-04-10 19:47
Shared centralized database location	smande00	General Development (no feature request here!)	0	2006-03-30 01:16
Video Jumping when i run from shared folder	drcreek	General Support	2	2006-01-09 16:35
Shared (Networked) database files	samedney	Improvement Suggestions	2	2005-01-28 16:54

2008-03-03, 16:22	#3 (permalink)
Vampiro Portal Member Join Date: Jan 2008 Age: 35 Posts: 68 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	I cmoved all my movies to an external ethernet hard drive. Is it possible to edit the movie database to change the path were my videos are now stored insted of import all ther info again? And how? Thanks

2008-03-03, 17:04	#4 (permalink)
rick78 Portal Member Join Date: Feb 2006 Location: Copenhagen, Denmark Age: 41 Posts: 61 Thanks: 6 Thanked 0 Times in 0 Posts Country:	Good question. I am interested in hearing if it possible edit the data in the database as well.

2008-03-03, 17:12	#5 (permalink)
allanp81 Portal Member Join Date: Oct 2006 Posts: 465 Thanks: 2 Thanked 7 Times in 7 Posts	No for the reasons specified by charli181. You cannot share the databases between clients apart from having 1 "master" and copying to all other clients.

2008-03-03, 17:19	#6 (permalink)
Vampiro Portal Member Join Date: Jan 2008 Age: 35 Posts: 68 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	I don't want to share the databases, only to change the path inside those databases...

2008-03-03, 17:26	#7 (permalink)
allanp81 Portal Member Join Date: Oct 2006 Posts: 465 Thanks: 2 Thanked 7 Times in 7 Posts	You need a browser that can view and edit the sqlite database then. Do a quick search in google.

2008-03-03, 19:58	#9 (permalink)
rick78 Portal Member Join Date: Feb 2006 Location: Copenhagen, Denmark Age: 41 Posts: 61 Thanks: 6 Thanked 0 Times in 0 Posts Country:	Thanks guys. I found that on Sourceforge. It seems to do the trick. /Rick