2 XBMC PCs and 1 Database on the shared NAS - Printable Version
+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- albaranov - 2010-09-06 04:02
Great! Good luck with 100,000 files. Alex
- charrua - 2010-09-06 12:47
albaranov Wrote:Hi Charrua,Very good tips! Thanks.
- Talguy - 2010-09-10 21:40
So I am about to build my first XBMC HTPC and would like to go with a centrailized DB and have lite frontend clients. My question is when I add new content to XBMC i.e. a movie how does it get added to the mysql database. Also how would I be able to add the scraped data for that file to the database.
- pregi - 2010-09-12 18:24
is there an Option to set timeout for MySQL DB?
sometimes my MySQL Server is down, because of this xbmc hangs and is nearly unusable
Unable to open database: xbmc_video (0) - dora - 2010-09-18 22:36
I'm trying to use the MySql external db feature but unfortunately, I can't make it work.
I'm using MySql server 5.5 and XBMC Dharma beta 2, both running on the same machine (Windows 7).
Looking in XBMC logfile, I can see the following error:
I also tried to use latin1 as server character set and collation.
- Soul - 2010-09-18 22:40
Have you actually created the databases, and not just the user?
Just checking - you might be expecting XBMC to create the dbs on first run or something.
- dora - 2010-09-18 23:10
Soul Wrote:Just checking - you might be expecting XBMC to create the dbs on first run or something.
Actually, I did expected XBMC to create the dbs on the first run, shouldn't I?
If I do need to create them by myself, can you give me a hint how to do it?
I already spent more than 5 hours to make it work before I decided to ask for help.
- craigd - 2010-09-19 00:31
Soul Wrote:Have you actually created the databases, and not just the user?
xbmc does create the databases on first run.
it looks like you've had the db created with an old xbmc build and the database has changed. try dropping the schemas from your sql server and restart xbmc
- dora - 2010-09-19 09:29
craigd Wrote:it looks like you've had the db created with an old xbmc build and the database has changed. try dropping the schemas from your sql server and restart xbmcI think that I did more than that. I completely unintalled MySql 5.1 and installed MySql 5.5. I thought that the problem might be that I'm not using the last version of MySql but that didn't help.
I don't know anything about schemas, what do you mean by dropping them? how do I do that?
Since I'm using XBMC in portable mode (-p switch), I also tried to delete XBMC\portable_data\userdata folder but that didn't help either.
It looks like you do have to create the databases by yourself.
I followed the instructions on: http://lifehacker.com/5634515/how-to-synchronize-your-xbmc-media-center-across-every-room-in-the-house and the errors on the log disappeared.
- avus m3 - 2010-09-20 06:29
I have a quick question about using the centralized DB setup. I have it working on my machines being able to resume paused play in another room etc. One problem I have is I added a few episodes of different shows and it's not adding them?? I selected to update library (have it update on startup as well) but it doesn't add the show episodes. Everything works besides not able to add episodes. Any ideas?