2011-02-04, 22:59
I have 3 systems running XBMC all in sync to the same mysql db.
Everything works great on the db side.
I also have a server (Sun Ultra 60) that runs the mysql db as well as sickbeard and couchpotato that is a separate machine from all my XBMC enabled machines. All the media is stored on a buffalo 2TB NAS which is a mount on the Sun box.
I have one XBMC system setup to do a library update on start-up which works but means that my library only gets updated when that machine has XBMC restarted, or when a command is sent from sickbeard to run a library update.
Although when the db was local not mysql it made sense to only update on restart but with the db offloaded is there a better way?
Is there some sort of linux/windows shell/batch script that can scan the folders of my NAS and update the mysql library with new episodes/movies?
I checked a few forums and found one on the sickbeard web-site where they were asking sickbeard to implement a direct write to the mysql db from sickbeard which seems overly complicated.
http://sickbeard.com/forums/viewtopic.php?f=8&t=505
Pretty much I am looking for a quick and dirty way to run a library update without having to do it within XBMC.
Everything works great on the db side.
I also have a server (Sun Ultra 60) that runs the mysql db as well as sickbeard and couchpotato that is a separate machine from all my XBMC enabled machines. All the media is stored on a buffalo 2TB NAS which is a mount on the Sun box.
I have one XBMC system setup to do a library update on start-up which works but means that my library only gets updated when that machine has XBMC restarted, or when a command is sent from sickbeard to run a library update.
Although when the db was local not mysql it made sense to only update on restart but with the db offloaded is there a better way?
Is there some sort of linux/windows shell/batch script that can scan the folders of my NAS and update the mysql library with new episodes/movies?
I checked a few forums and found one on the sickbeard web-site where they were asking sickbeard to implement a direct write to the mysql db from sickbeard which seems overly complicated.
http://sickbeard.com/forums/viewtopic.php?f=8&t=505
Pretty much I am looking for a quick and dirty way to run a library update without having to do it within XBMC.