MySQL/Setting up Kodi
< MySQL
Jump to navigation
Jump to search
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 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.