Centralized database

Hi all

I now have three xbmc's running in the house, the latest being on a new Zotac MAG, and the others on original XBOX machines.

Now that the Zotac is proving itself, I am keen to replace the xbox's.

One thing I want to do is have a centralized database on the server so that I dont have to scan the media on every box every time there is something new added. I know I can import and export, but that is still a manual process.

What I want to be able to do is have an option for a remote database, specify the location and have all boxes in the house use it, that way when I scan for new media on one, all of them will have the data available.

This should work with a local database so that content specific to the local machine is also available and the two databases are merged.

Sorry if this has been done but I did not find any reference to this.

Ok - I found reference to a centralized data base - a mysql database on a server and edditing files on the boxes. I have not seen reference to merging the datbases at all though (one local and one remote).

Mick

My understanding is the mysql support is still very new - don't want to discourage you from using it, but it is pretty experimental at this point as far as I know. Also, it is all or nothing I believe - I'm pretty sure there is no support for "mixing" between a local sqlite database and using a remote mysql database.

If you feel up to it by all means go ahead and experiment with the mysql stuff - but if you are expecting it all to "just work" at this point (especially if you have an xbox involved) I would look at just doing the synchronization manually (or not at all).

Read up on the mysql support (here is some info - there is probably lots more if you look around). If it all sounds too complicated... Well you should probably wait a while until the mysql stuff is stabilized a bit. Also, keep in mind that mysql support is not likely to ever reach xbmc4xbox (that is not one of their priorities from my understanding), so you may never be able to mix an xbox into this kind of setup.