MySQL/Setting up Kodi: Difference between revisions
< MySQL
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
{{:HOW-TO:Sync multiple libraries/Contents}} | {{:HOW-TO:Sync multiple libraries/Contents}} | ||
{| class=infobox | |||
| advancedsettings.xml: | |||
|- | |||
| | |||
<pre><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></pre> | |||
|} | |||
#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''' | |||
#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 <code>***.***.***.***</code> 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:''' <code>Documents and Settings\<your_user_name>\Application Data\XBMC\userdata\advancedsettings.xml</code> | |||
#* '''Vista/Windows 7:''' <code>Users\<your_user_name>\AppData\Roaming\XBMC\userdata\advancedsettings.xml</code> | |||
#* '''Mac OS X:''' <code>/Users/<your_user_name>/Library/Application Support/XBMC/userdata/advancedsettings.xml</code> | |||
#* '''iOS:''' <code>/private/var/mobile/Library/Preferences/XBMC/userdata/advancedsettings.xml</code> | |||
#* '''Linux:''' <code>$HOME/.xbmc/userdata/advancedsettings.xml</code> | |||
#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 | |||
#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. | |||
{{editor note|mention that all XBMC devices must have the same sources (network paths), or at least sources that have "content set", for files/library to be updated from any XBMC device. Maybe even pathsubstitution for sources.xml? (or save that for some "total sync" guide?)}} |
Revision as of 00:58, 5 February 2012
HOW-TO:Sync multiple libraries/Contents
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 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
***.***.***.***
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:
- 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.