MySQL/Setting up Kodi: Difference between revisions
< MySQL
Jump to navigation
Jump to search
(→Steps) |
(→Steps: need to confirm if music can export/import) |
||
Line 30: | Line 30: | ||
###Go to '''System/Settings -> Video -> Library''' and select '''Export library''' | ###Go to '''System/Settings -> Video -> Library''' and select '''Export library''' | ||
###Select '''Single file''' | ###Select '''Single file''' | ||
##Export the Music Library by doing the following: | <!--##Export the Music Library by doing the following: | ||
###Go to '''System/Settings -> Music -> Library''' and select '''Export library''' | ###Go to '''System/Settings -> Music -> Library''' and select '''Export library''' | ||
###Select '''Single file''' | ###Select '''Single file'''--> | ||
#Create (or add to, if you already have one) an advancedsettings.xml file: | #Create (or add to, if you already have one) an advancedsettings.xml file: | ||
##Open up a plain text editor | ##Open up a plain text editor | ||
Line 48: | Line 48: | ||
###Go to '''System/Settings -> Video -> Library''' and select '''Import library''' | ###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 | ###Select the file you saved from the first step when you exported your video library | ||
##Import the Music Library by doing the following: | <!--##Import the Music Library by doing the following: | ||
###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--> | ||
#You can now add files and update the library from any of your XBMC devices and the library for all of them will stay in sync. | #You can now add files and update the library from any of your XBMC devices and the library for all of them will stay in sync. | ||
*'''NOTE:''' If you want to update the library from any of the XBMC devices then they must all have the same sources set. See '''[[HOW-TO:Sync multiple libraries/Sync other parts of XBMC|the Sources section of Part 6]]''' for one method of keeping them in sync. | *'''NOTE:''' If you want to update the library from any of the XBMC devices then they must all have the same sources set. See '''[[HOW-TO:Sync multiple libraries/Sync other parts of XBMC|the Sources section of Part 6]]''' for one method of keeping them in sync. |
Revision as of 10:20, 7 March 2012
HOW-TO:Sync multiple libraries/Contents Each device that will be sharing a library will need an advancedsetting.xml file.
Steps
advancedsettings.xml: |
<advancedsettings> <videodatabase> <type>mysql</type> <host>***.***.***.***</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> </videodatabase> <musicdatabase> <type>mysql</type> <host>***.***.***.***</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> </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 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
***.***.***.***
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 Video Library by doing the following:
- You can now add files and update the library from any of your XBMC devices and the library for all of them will stay in sync.
- NOTE: If you want to update the library from any of the XBMC devices then they must all have the same sources set. See the Sources section of Part 6 for one method of keeping them in sync.