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)
- xopah - 2010-12-05 15:11
Im experiencing slow browsing times and it seams like XBMC is not using persistent connections to the DB and that is what's taking so long times. (login times)
Could this be true?
this it true from two different clients (XBMC 10.0-rc1 r35325)
Character set: latin1
SQL preview for CREATE DATABASE:
CREATE DATABASE `xbmc_video` /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */
Slow MYSQL access - atomfire - 2010-12-05 18:34
I had a similar problem with slow access to MYSQL when going into movies/tvshows in my case it only affected 1 of my machines not both. Turns out MYSQL was trying to resolve the hostname of the machine running the query, I have no DNS server in the house therefore the query failed causing the delay. To resolve I added the IP and hostname to c:\windows\system32\drivers\etc\hosts on the machine running MYSQL this resolved the issue for me.
- rossgemuend - 2010-12-12 06:03
To elaborate on atomfire's post, one should put the following line in their my.ini file (running mysql from windows file server) within the mysqld section. This fixed my slow navigation while in Ubuntu.
- pregi - 2010-12-12 23:32
on my music db i have the same artists tagged with different names like artist1 and artist 1 ...
can i set those different names to one idArtist in mysql?
- castortray - 2010-12-17 18:39
There is new version of MySQL Community Server 5.5.8:
Essentials version still 5.1.54
Someone test it ?
- castortray - 2010-12-17 23:25
I wrote a short instruction How to configure XBMC with MySQL step by step.
I use xbmc on 4 pc, and I love this synchronization.
Now I need to think how to automatically create backup of database once a week and save last three backups.
Any help is appreciated
- MrDVD - 2010-12-18 00:33
castortray Wrote:Now I need to think how to automatically create backup of database once a week and save last three backups.Thats an easy step
Im sure google know 100000000 such scripts on windows or linux, dont know which OS you are running. I used one under linux and it was a simply shell script where you can say then/where/what and so on.
Simply search at google for "automatic mysql backup script"
- castortray - 2010-12-18 00:40
MrDVD Wrote:Thats an easy step
Of course you have right
I just though that someone already has it, and can share it
but you're right, there is no problem with that script...
I need to start looking
btw: I'm using Windows 7
- MrDVD - 2010-12-18 01:09
I think in most cases its just a add of data like user/pwd/db name.
Live CD to Access MySQL Database - ti_gusus - 2010-12-22 01:45
I'm actually using MySQL with XBMC running on Windows 7 HTPC. I did mklink for the Thumbnails and mod on the advancedsettings.xml. Everything is working great under Windows...
Now, during christmas vacation, I would like to do some test with the Live CD. What should be modified inside the Live CD to get access to my MySql Server and my remote Thumbnails
Thank for your help