HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker

yes the recently added updates for me.

Thermos Wrote:yes the recently added updates for me.

Can I ask what Version and skin your running Thanks

sorry for the late reply ram2000. i am running Darhma RC1 and the skin Night.

It took me the best part of three days to find the one word in the MySQL Database: Multiple XBMC HTPC's with 1 Shared Library thread to get the centralised database working properly; so I figure it's worthwhile putting the solution here. The word is "latin1".

Initially, following the Lifehacker instructions looked like they worked, but I couldn't select Library Mode, and I couldn't show the "TV Shows" and "Movies" options on the main menu. It was all in the character/collation schema. It's now set to "latin1_general_ci" and it's all working fine (after deleting and recreating the relevent sources).

I assume it's all in the different representation of special characters between latin1 and my original selection of utf8...

Def_Proc Wrote:It took me the best part of three days to find the one word in the MySQL Database: Multiple XBMC HTPC's with 1 Shared Library thread to get the centralised database working properly; so I figure it's worthwhile putting the solution here. The word is "latin1".

Initially, following the Lifehacker instructions looked like they worked, but I couldn't select Library Mode, and I couldn't show the "TV Shows" and "Movies" options on the main menu. It was all in the character/collation schema. It's now set to "latin1_general_ci" and it's all working fine (after deleting and recreating the relevent sources).

I assume it's all in the different representation of special characters between latin1 and my original selection of utf8...

It seems PHPMyAdmin has defaulted to "latin1_swedish_ci" for all my tables.

i have a little problem when i try to sync the Thumbnails folder, my problem is that in "cmd" i cant get into my user folder to make the mklink command because it's called "^FrEaK^" , and it just fails because of some reason, i cant use "cd ^FrEaK^" to get in to it, it doesn't like the "^" infront of the name...

so does anyone know how i can get past that in cmd? or another way of making that symbolic shortcut (ordinary windows shortcut doesn't work)

Don't have special characters in your username? Seriously though I don't know. You don't have to go to the dir in the command prompt...just explicilty state it in the command of mklink. Problem is might still have issues with ^? Go try it.

Hi,

Thanks for a great guide. Looked easy, but didn't get it to work.

As fast as I add the advancedsettings.xml to my userdata folder and start XBMC the XBMC logo comes up and then it takes ages to start. And when it starts I cannot move around in the menues. I checked my mysql databases, both video and music and they are not populated with any new tables. Whole XBMC feels hung up.

I ran these commands in my mysql server:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;
CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
GRANT ALL ON *.* to 'xbmc';
FLUSH PRIVILEGES;

My advancedsettings XML:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.111</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.0.111</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>

I have verified my connection to the database server from my XBMC mahcine that runs Windows7. It works fine and my xbmc database user have full privileges to the two xbmc databases that I created.

Anyone have any ideas on wy this is happening?

avus m3: didn't work, so i desided to do it the hard way and just make a new windows user without special characters and transfer all the xbmc and windows settings to the new user

pig13t: have you tried a clean install? my xbmc on one of the computers where acting up, and i just needed to make a completely clean install, and add the library again (witch takes AGES the first time ) and then it worked much better

^FrEaK^ Wrote:pig13t: have you tried a clean install? my xbmc on one of the computers where acting up, and i just needed to make a completely clean install, and add the library again (witch takes AGES the first time ) and then it worked much better

I just removed beta4+my profile and installed RC2. So it's pretty clean.

Is it supposed to take a very long time the first time? And during that time, how did your XBMC act?