MySQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 20: | Line 20: | ||
==Setting up XBMC== | ==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''' | |||
[[Category:How-to]] | [[Category:How-to]] |
Revision as of 00:11, 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), 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