XBMC Community Forum
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)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

- 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)

advancedsettings.xml
Code:
<advancedsettings>
<videodatabase>
    <type>mysql</type>
    <host>192.168.10.11</host>
    <port>3306</port>
    <user>xbmc_video</user>
    <pass>jxxxL</pass>
    <name>xbmc_video</name>
</videodatabase>
</advancedsettings>

sources.xml
Code:
<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>MOVIES</name>
            <path pathversion="1">smb://192.168.10.19/storage2/MOVIES/</path>
            <path pathversion="1">smb://192.168.10.19/storage3/MOVIES_2/</path>
        </source>
        <source>
            <name>TV_SHOWS</name>
            <path pathversion="1">smb://192.168.10.19/storage2/TV_SHOWS/</path>
            <path pathversion="1">smb://192.168.10.19/storage3/TV_SHOWS_2/</path>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
    </music>
    <pictures>
        <default pathversion="1"></default>
    </pictures>
    <files>
        <default pathversion="1"></default>
    </files>
</sources>


Database Settings:
Character set: latin1
Collation: latin1_swedish_ci
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.

Code:
[mysqld]

skip-name-resolve


- pregi - 2010-12-12 23:32

hi
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

Hi,

There is new version of MySQL Community Server 5.5.8:
http://dev.mysql.com/downloads/mysql/5.5.html#downloads
Essentials version still 5.1.54
Someone test it ?

- castortray - 2010-12-17 23:25

Hi,
I wrote a short instruction How to configure XBMC with MySQL step by step.
xbmc_mysql
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 Smile

- 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.
Any help is appreciated Smile
Thats an easy step Smile
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 Smile
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"

Of course you have right Smile
I just though that someone already has it, and can share it Smile
but you're right, there is no problem with that script...
I need to start looking

btw: I'm using Windows 7

cheers !!

- 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 Confused

Thank for your help