+- 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: Cross Platform MySQL support (/showthread.php?tid=176141)
Cross Platform MySQL support - bennyboi04 - 2013-10-20
Evening all,
for the last year i have run a centralised MySQL server to enable library sharing no problem amongst all my Windows devices.
The problem i have is i have now introduced 2 OpenELEC devices (PC and RaspberryPi) and on these devices i can see my library but nothing will play (File no longer available...)...
I have worked out why, its because windows uses '\' where as the linux boxes appear to require '/'
Could someone please help me make my database cross platform able
Many thanks in advance
Ben
RE: Cross Platform MySQL support - Ned Scott - 2013-10-21
Export the library (multiple files), drop the MySQL databases, rescan library using the correct paths. Basically, the same process used for going local to MySQL: MySQL (wiki)
RE: Cross Platform MySQL support - bennyboi04 - 2013-10-21
(2013-10-21, 05:36)Ned Scott Wrote: Export the library (multiple files), drop the MySQL databases, rescan library using the correct paths. Basically, the same process used for going local to MySQL: MySQL (wiki)
Thanks Ned, but if I do this will I not end up with the same issue again but this time on my windows boxes?
Cheers again
RE: Cross Platform MySQL support - Ned Scott - 2013-10-21
There will be no issue. Windows can understand both forward and back slashes.
RE: Cross Platform MySQL support - bennyboi04 - 2013-10-21
(2013-10-21, 10:01)Ned Scott Wrote: There will be no issue. Windows can understand both forward and back slashes.
Thanks Ned that's a great help... I don't suppose you would be able to supply more in depth instructions would you please? My MySQL experience is extremely limited.
Thanks
Ben
RE: Cross Platform MySQL support - bennyboi04 - 2013-10-21
(2013-10-21, 10:01)Ned Scott Wrote: There will be no issue. Windows can understand both forward and back slashes.
http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Update_Paths_In_MySQL
I believe this is what you mean?
RE: Cross Platform MySQL support - bennyboi04 - 2013-10-21
(2013-10-21, 13:32)bennyboi04 Wrote:(2013-10-21, 10:01)Ned Scott Wrote: There will be no issue. Windows can understand both forward and back slashes.
http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Update_Paths_In_MySQL
I believe this is what you mean?
Done this successfully now thanks ned for your help
RE: Cross Platform MySQL support - Ned Scott - 2013-10-21
Good to hear!