Posts: 4
Joined: Dec 2014
Reputation:
0
Not sure I follow? As far I know, yes. What should I check?
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
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 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 4
Joined: Dec 2014
Reputation:
0
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)
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
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 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 124
Joined: Jul 2010
Reputation:
0
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.
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
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 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 4
Joined: Dec 2014
Reputation:
0
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
Posts: 182
Joined: Dec 2011
Reputation:
2
D-an-W
Senior Member
Posts: 182
Has anyone got this setup using OS X Yosemite (10.10.1) as the server for MySQL?
I installed mysql-5.6.22-osx10.9-x86_64.dmg and tried to follow the guide but when trying to copy the file using "sudo cp my-huge.cnf /etc/my.cnf" it failed as there is no such file to copy.
It seems Yosemite has a problem launching MySQL on startup, can anyone confirm a fix for this?
Posts: 6
Joined: May 2014
Reputation:
0
Can anyone explain why when there's a DB change, I get a new DB with the new DB version number, but no data gets written to it (and the new version then crashes every time it gets started after that)?
I thought it might be the RaspBMC build of Kodi not working right, but the official Windows version does exactly the same thing. Drop the empty table, run the new version, and it creates a blank DB with the new name. No tables are created, and certainly no data is copied.
I have checked the permissions as best I can - the user I'm using now has full global privileges, and it still just creates a blank DB.
What can I do to further debug this rather painful problem?
Posts: 214
Joined: Feb 2013
Reputation:
7
I'm preparing to set up MySQL for 3 Kodi 14.0 installations in my home. I've seen warnings earlier to not use a MySQL version later than 5.5, but I don't know how old those warnings are, or if they still apply to Kodi. Is that still the recommended version, or is it safe to go with the newest, 5.6.x?
Posts: 567
Joined: Jun 2012
Reputation:
24
I'm using MySQL 5.6.20 on Windows and have had no problems
Posts: 214
Joined: Feb 2013
Reputation:
7
^Thanks for the replies, folks. I went ahead and installed 5.5 on my Windows 7 Pro file server, set up my Kodi installations, and all seems to be working great!