MySQL/Setting up Kodi: Difference between revisions
< MySQL
Jump to navigation
Jump to search
>Zackb No edit summary |
(revert, this is what the HOW-TO:Sync multiple libraries/Portable devices and profiles page is for.) |
||
Line 3: | Line 3: | ||
{{-}} | {{-}} | ||
== | ==Steps== | ||
{| class=infobox | {| class=infobox | ||
| advancedsettings.xml: | | advancedsettings.xml: | ||
Line 15: | Line 15: | ||
<user>xbmc</user> | <user>xbmc</user> | ||
<pass>xbmc</pass> | <pass>xbmc</pass> | ||
</videodatabase> | </videodatabase> | ||
Line 24: | Line 23: | ||
<user>xbmc</user> | <user>xbmc</user> | ||
<pass>xbmc</pass> | <pass>xbmc</pass> | ||
</musicdatabase> | </musicdatabase> | ||
</advancedsettings></pre> | </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)'' | #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 | ##Export the Video Library by doing the following: | ||
###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 | ||
##Copy and paste the text from the right-hand box into a new text document | ##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 | ##Replace the two instances of <code>***.***.***.***</code> with local network IP address of your MySQL server | ||
##Save the file as '''advancedsettings.xml''' | ##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: | #Copy this ''advancedsettings.xml'' file you just created to the userdata folder of every XBMC install you want to sync with: | ||
Line 65: | Line 53: | ||
#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 05:14, 27 April 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 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.
- 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.
- NOTE: If you encounter error 1062, then you'll need to change your paths from "\\" to "//" as MySQL has trouble understanding "\\"
- NOTE: If you are using Eden, the video MySQL database will have 60 appended to the name (ex. video_database60). The music MySQL database will have 18 appended to the name (ex. music_database18).