MySQL
Jump to navigation
Jump to search
Notice: These instructions require the latest nightly build of XBMC (pre-Eden v11)
Into about what this is and how cool it is to sync XBMC libraries goes here
Selecting a server
Something about needing to choose which of your XBMC boxes (or NAS box) will be the MySQL server. Needs to be on 24/7 or have wake-on-lan (preferably the former), needs to have a static local IP, etc.
Setting up the MySQL server
- Download a copy of MySQL server for your OS: http://dev.mysql.com/downloads/mysql/
- Run the installer and select the Standard configuration
- Create a password when asked
- Select that you want the database to have network access
- Get into the MySQL command line interface.
- Windows: Open the "MySQL Command Line Client" from the MySQL start menu
- Type in:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
and press return - Type in:
CREATE database xbmc_video;
and press return - Type in:
CREATE database xbmc_music;
and press return - Type in:
GRANT ALL ON *.* TO 'xbmc';
and press return
- Close out the command line tool
Setting up XBMC
- Open XBMC on the computer that has the library you want to share (If you have not created a library yet you can skip to X)
- Export the Video Library by doing the following:
- Go to System/Settings -> Video -> Library and select Export library
- Select Single file
- Export the Music Library by doing the following:
- Go to System/Settings -> Music -> Library and select Export library
- Select Single file
- Create (or add to, if you already have one) an advancedsettings.xml file:
- Open up a plain text editor
- Copy and paste the text from this page into a new text document
- ave the file as advancedsettings.xml