MySQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 69: | Line 69: | ||
###Go to '''System/Settings -> Music -> Library''' and select '''Import library''' | ###Go to '''System/Settings -> Music -> Library''' and select '''Import library''' | ||
###Select the file you saved from the first step when you exported your music library | ###Select the file you saved from the first step when you exported your music library | ||
==Syncing thumbnails and fanart== | |||
Pathsub instructions go here | |||
[[Category:How-to]] | [[Category:How-to]] |
Revision as of 00:50, 14 November 2011
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
advancedsettings.xml: |
<advancedsettings> <videodatabase> <type>mysql</type> <host>***.***.***.***</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> <name>xbmc_video</name> </videodatabase> <musicdatabase> <type>mysql</type> <host>***.***.***.***</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> <name>xbmc_music</name> </musicdatabase> </advancedsettings> |
- Open XBMC on the computer that has the library you want to share (If you have not created a library yet you can skip this step)
- 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
- Export the Video Library by doing the following:
- 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 the right-hand box into a new text document
- Replace the two instances of
<host>***.***.***.***</host>
with local network IP address of your MySQL server - Save the file as advancedsettings.xml
- Copy this advancedsettings.xml file you just created to the userdata folder of every XBMC install you want to sync with:
- Windows XP:
Documents and Settings\<your_user_name>\Application Data\XBMC\userdata\advancedsettings.xml
- Vista/Windows 7:
Users\<your_user_name>\AppData\Roaming\XBMC\userdata\advancedsettings.xml
- Mac OS X:
/Users/<your_user_name>/Library/Application Support/XBMC/userdata/advancedsettings.xml
- iOS:
/private/var/mobile/Library/Preferences/XBMC/userdata/advancedsettings.xml
- Linux:
$HOME/.xbmc/userdata/advancedsettings.xml
- Windows XP:
- Open any of your XBMC installs and re-import your library data (If you have not created a library yet you can skip this step)
- Import the Video Library by doing the following:
- Go to System/Settings -> Video -> Library and select Import library
- Select the file you saved from the first step when you exported your video library
- Import the Music Library by doing the following:
- Go to System/Settings -> Music -> Library and select Import library
- Select the file you saved from the first step when you exported your music library
- Import the Video Library by doing the following:
Syncing thumbnails and fanart
Pathsub instructions go here