RockDawg Wrote:I can't believe I overlooked that. Thanks so much!

RockDawg Wrote:I'm a little confused on this part. From what I read mklink is a Windows command. In my situation the server is Win but the clients are Linux. What would be the proper command?

RockDawg Wrote:Thanks. I'll try that when I get home from work.
A strange thing I noticed was when I got XBMC using the db on the server. I tried to import my movies from the .xml file and I could see what looked like them scanning in, but when I woke up this morning and checked it out. XBMC acted as though there was no library. I figured I would go into files mode and set content and re-scan them in, but "exclude folder from scans" was checked and I couldn't uncheck it. I was leaving for work and didn't have much time to investigate, but does anyone have an idea what the problem could be?

lestat1977uk Wrote:Thanks i have now managed to get it to work by using remote paths, so once i have my main video database all compiled, how do i keep all the Fanart, thumbs etc in sync?
I know there is some discussion on this including using remote cache paths (which i am keen to try) but what would you suggest being the easiest way?

lestat1977uk Wrote:Another quick question rather than use mysql can i use sql 2005 express or even sql 2008?

charrua Wrote:Do you have any local paths defined as media sources?

charrua Wrote:Yes, I believe you are correct.
Also be aware that there is another temporary solution for the thumbnail cache, originally suggested by MrDVD: symlinking a network shared folder as a common central cache, that way you don't even have to use Sugarsync for syncing thumbnails. The only cons I've found so far with that approach is that XBMC GUI speed suffers a little (at least in my tests) compared to XBMC using a local image cache, and the other issue is that if you loose connection to the network shared cache folder XBMC won't be able to show any poster, fanart, etc. Other than that is a very good temporary solution.

RockDawg Wrote:Oddly when I got home from work, my library was showing. The problem now is that navigation is painfully slow. Entering the my movies library from the home screen takes like 20 seconds. Clicking on "movie info" takes about 8 seconds for the info window to pop up. And that is with me only using the centralized db. I haven't even messed with the thumbs yet. Everything is gigabit network. Anybody else experience anything like this or have any suggestions?

RockDawg Wrote:I never thought to check, but yah there's some weird stuff in there:
http://pastesite.com/14989

craigd Wrote:I've been playing with new svn's and decided tot ry this on my laptop so as not to disrupt my htpc's but having probs.
I've installed sql on my server and created xbmc user with full rights.
It appears to scan and create the db ok but when I go to the movies view there is nothing listed.
I ran a debug and am getting multiple errors of "ERROR: Can't open the database xbmc_video as it is a NEWER version than what we were expecting!"
does anyone know if this is an issue with the svn or sql, don;t want to start messing with my main installs until I've tested it all working?

lestat1977uk Wrote:Hi all
Just wanted to give you guys some feedback, got 3 machines now setup using mysql and works a treat! (Thanks Charrua)
I've also been playing around with using symbolic links to thumbnails on the main server for the other 2 machines.
Whilst it does work it does take quite a long time to load up the image! i think what is really needed is a local cache and a remote one, ie everytime you open up xbmc it pulls from the remote thumbnails folder into its own local folder, that way it would only ever be slow when making a quite update?
Interestingly though i found that making symbolic links to plugins scripts etc.. work really well and saves the need to have to keep plugins and other programs the same on all xbmcs.
Your thoughts guys?

charrua Wrote:I don't think the errors that show in your log are causing the slowdown you describe, could it be just due to the server hosting MySQL not being fast enough? In my case XBMC running on MySQL remote db is only a couple of seconds slower than the same XBMC instance running on a local SQLite db.

RockDawg Wrote:It's running on a Win7 machine with a C2D E6550 w/2GB RAM. While I know it's nowhere near an up-to-date machine, I though it would be more than fast enough considering that, A. MySQL is touted as fast and light weight and B. others are doing this on a NAS which aren't usually very powerful.