Kodi Community Forum
MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library (/showthread.php?tid=85654)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Mandar666 - 2014-12-11

Not sure I follow? As far I know, yes. What should I check?


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2014-12-11

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?


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Mandar666 - 2014-12-12

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)


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2014-12-12

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.


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - GregiBoy - 2014-12-12

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.


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2014-12-12

Or indeed you could do that kind of change directly on the mysql database if you knew a bit of SQL.


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Mandar666 - 2014-12-12

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


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Waltman - 2014-12-25

I don't want to post in two sections, but i found some speed differences with mysql between Gotham and Kodi. I thought it was OSX related, but i am doubting that now.

Please check it out here : http://forum.kodi.tv/showthread.php?tid=212116&pid=1870606#pid1870606


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - D-an-W - 2014-12-29

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?


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - tin2001 - 2015-01-01

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?


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - guido66 - 2015-01-01

Check out this thread: http://forum.kodi.tv/showthread.php?tid=212218

Looks very much like that problem


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - pagali - 2015-01-06

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?


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Ardalista - 2015-01-07

(2015-01-06, 19:16)pagali Wrote: 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?

I'm still running MYSQL version 5.5 on my ubuntu server.

I believe the same issues persists though I've not installed 5.6 in a while to check up on it since I had issues way back when.


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - zerocool_ie - 2015-01-07

I'm using MySQL 5.6.20 on Windows and have had no problems


RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - pagali - 2015-01-07

^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!