MySQL Database: Multiple XBMC HTPC's with 1 Shared Library

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
Mandar666 Offline
Junior Member
Posts: 4
Joined: Dec 2014
Reputation: 0
Post: #346
Not sure I follow? As far I know, yes. What should I check?
find quote
nickr Online
Donor
Posts: 9,903
Joined: May 2009
Reputation: 178
Location: Christchurch NZ
Post: #347
So which machine has the files stored on it?

How are you sharing the files? I guess smb?

When you added sources on the original machine did you add them via smb shares or as local files?

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
Mandar666 Offline
Junior Member
Posts: 4
Joined: Dec 2014
Reputation: 0
Post: #348
Ah, got it.
- All files are stored locally on the same HTPC running my MySQL. When I set up MySQL I already had an extensive library going, so I just imported my library after installing MySQL.
- Checking the DB, I see the paths are all saved as local paths (e.g. E:\Movies\Boxsets\Indiana Jones - Trilogy\01 - Indiana Jones - Raiders of the lost Ark.avi)
find quote
nickr Online
Donor
Posts: 9,903
Joined: May 2009
Reputation: 178
Location: Christchurch NZ
Post: #349
Thats the problem then. The clients can't follow that path.

I think the solution is to end up with all computers accessing via smb, even the local computer (it should be able to access it's own shares even though that seems counter-intuitive).

I think that will mean deleting all your sources and deleting the database, then adding them as smb shares. Then rescrape. If you export your database to indivdual files first it will ease the process at the expense of cluttering up your media directories with .nfo files.

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
GregiBoy Offline
Member
Posts: 86
Joined: Jul 2010
Reputation: 0
Location: Brisbane, Australia
Post: #350
You could also export the database to a single file and do a global search/replace of the local path(s) to the SMB paths.

I've done this with notepad+ a few times for friends.
find quote
nickr Online
Donor
Posts: 9,903
Joined: May 2009
Reputation: 178
Location: Christchurch NZ
Post: #351
Or indeed you could do that kind of change directly on the mysql database if you knew a bit of SQL.

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
Mandar666 Offline
Junior Member
Posts: 4
Joined: Dec 2014
Reputation: 0
Post: #352
Awesome thanks.

- Plan A would be to backup DB, then write script and update DB
- Plan B would be to restore DB, notepad++ it
- Plan C is to wipe and start from scratch
find quote
Post Reply