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)
- ringgh0st - 2010-08-17 16:31
kurt, believe me. I AM a MySQL noob (still after installing Mysql, appache and the whole stuff). but you cant make a mistake when you follow 100% one of the tutorials for installing WAMP and MySQL on a windows machine (check ghacks, lifehacker or some other great page). when you got it running simply paste the advancedsettings.xml described in this thread and youre done. nothing more.
- craigd - 2010-08-17 16:36
All you need to know is in the second post of this thread.
You don't need wamp, phpmyadmin, workbench or anything else. You don't need to create tables or know anything about sql.
some of these can help but they should not be essential
the step by step therefore is...
1. download mysql
2. install mysql
3. add entries to advancedsettings.xml as described in post 2
4. enjoy...xbmc will create the required schemas according to what you've named them in the xml file and populate all the required tables etc. just rescan your library in as you would normally.
If you've done that and experience problems post here, if you have problems with user permissions or want to view databases the simplest way is using mysql workbench which provides a pretty simple gui for viewing databases.
- ringgh0st - 2010-08-17 16:43
craigd Wrote:All you need to know is in the second post of this thread.
as i said. im a mysql noob thx craig
- craigd - 2010-08-17 17:12
ringgh0st Wrote:as i said. im a mysql noob thx craig
sorry mate, didn't intend that as a dig at your advice, wamp is an easy automated way to get sql and php stuff installed but installs stuff that isn't needed just for this.
your advice was spot on would definitely work but apparently looking it up was too much work .
- zephyr - 2010-08-18 12:34
I have a big problem with my latest install.
I use Dharma 32894 and I just can't get the MySql DB to work.
I have used this setup before on an earlier rev, but now it just won't work.
- Gryph - 2010-08-23 15:29
I'd be checking your database in MySQL ... As looking at your log I see a lot of:
"ERROR: SQL: The table does not exist"
If you have phpmyadmin installed, you can easily check you database (instead of running raw console commands)
- Handa - 2010-08-23 15:33
Try to delete the MySQL-database and then re-create it. When you first start XBMC with MySQL set-up you need to let it create all the tables which take about 10-20 seconds.
I remember that I thought XBMC had crashed when I was first starting with the database and I killed the process before it had created all the tables.
- rooster790 - 2010-08-23 16:23
jackthegroove Wrote:Is the problem with the extra parameters for recentlyadded already fixed? (it's a problem that only occurred when using the mysql database)
Got the same issue here using the AEON skin (Media Stream works fine) - Has anyone heard anything about this?
- mwkurt - 2010-08-26 22:22
I hope that you or someone can help me out. I finally tried to configure this and am not sure if it took.
I am using build 33122-Dharme.exe
Steps I took:
1. Downloaded and installed "mysql-essential-5.1.50-win32.msi "
2. Exported my Current DB to a single file.
This produced the following:
a folder called "xbmc_videodb_2010-08-26"
inside the folder are 4 more folders:
actors, movies, musicvideos, tvshows
Also an xml file: videodb.xml
3. Made an advancedsettings.xml file with the following inside:
This was placed in my usedata folder at C:/users/server/appdata/roaming/xbmc/userdata
3.opened xbmc and did not get any indication of anything being done as far as mysql is concerned.
Tried to import my database. I assumed that xbmc would allow me to choose the xml file "videodb.xml", but it did not.
I am lost. Can someone point me to the error of my ways?
How will I know if it is working or not, what can I check?
- mwkurt - 2010-08-27 02:32
As a continuation of the plea for help above I am writing this.
I tried to install mysql again. I think because I reinstalled mysql more than once, I got an error message on the security settings, so I installed without security settings. Is that okay?
Now.....when I add the advancedsettings.xml with the videodb part, as described in the 2nd post of this thread, my "Movies" and "TVShows" selections on my home menu disappear and I can not get into Library mode. Is that what is supposed to happen?
After importing my db back into XBMC, those two menu items are still not there. Anything I can do short of reformatting? All help is appreciated.