MySQL/Setting up Kodi

From Official Kodi Wiki
Jump to navigation Jump to search

Share libraries w/MySQL, guide:

  1. Introduction
  2. Setting up MySQL
  3. Setting up Kodi
Home icon grey.png   ▶ MySQL ▶ Setting up Kodi

Each device that will be sharing a library will need an advancedsetting.xml file.


Make files accessible over the network

If you haven't already done so, you will need to make your media files accessible to all your XBMC devices by sharing them on the network through file sharing. XBMC itself or the MySQL server will not share the actual files for this setup. Most operating systems have built-in methods for sharing files to the network, or a NAS device can be used.


Note:

  • If you use passwords on your network shares then you will need to copy (or sync) your passwords.xml file from the userdata folder to each XBMC device.
  • Do not use mapped drives on the OS-level, as XBMC will see those as local drives.
  • If you use smb:// paths, you may want to use static IP addresses rather than NetBIOS names, as not all your devices may be able to resolve the latter.
  • Even if the media is on the same computer as one of the XBMC instances, you MUST use a network share path. You cannot use a local file path with MySQL.


See Category:File Sharing for some of the file sharing methods that work with XBMC.

Exporting

Note: You only need to do the exporting steps if you are migrating an existing local library to a MySQL database. The MySQL setup creates an entirely new library on the MySQL server, so this step allows you to preserve your old library and restore it once MySQL is used in XBMC.

Warning: This will create individual ".nfo" and image files along side your video files. This is considered the safest way to backup and/or migrate a library (MySQL or otherwise), but some users might not want the file clutter. For an alternative method see here.


  1. Open XBMC on the computer that has the library you want to share
    1. Export the Video Library by doing the following:
      1. Go to System/Settings -> Video -> Library and select Export library
      2. Select Multiple files
    2. Export the Music Library by doing the following:
      1. Go to System/Settings -> Music -> Library and select Export library
      2. Select Multiple files

MySQL and advancedsettings.xml

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>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

See also this note about using the <name> tag: #Name tag
<importwatchedstate> is only needed when you're importing a previous library from exported files.

  1. Create (or add to, if you already have one) an advancedsettings.xml file:
    1. Open up a plain text editor
    2. Copy and paste the text from the right-hand box into a new text document
    3. Replace the two instances of ***.***.***.*** with local network IP address of your MySQL server. If you installed MySQL on a Windows machine, do not use its NetBIOS name, as not all devices may be able to resolve them.
    4. Save the file as advancedsettings.xml
  2. Copy this advancedsettings.xml file you just created to the userdata folder of every XBMC install you want to sync with.


Importing

At this point XBMC is using the MySQL server for the database, which means it has a new blank library. Now we can either import an old library (see below) or simply start a new library (see adding videos to the library). From this point on, XBMC behaves exactly like it would as if it had a local database, except that database is on the MySQL server and multiple XBMC installs can access that single database.


  1. Open any of your XBMC installs and re-import your library data, or simply set up a new library if you are starting fresh.
  2. Add (or just "set content" on) the networked video source to XBMC and scan it in as if you were setting up your library for the first time (see adding videos to the library). However, XBMC will read the exported nfo files and images and use those instead of rebuilding the library from scratch. The end result will be an identical library, and your watched status for videos will be preserved.
    Note: You must add a network source using XBMC's standard formatting. For example, use "smb://192.168.1.20/Videos/" and not "\\BOBPC\Videos\". Try to use static IP addresses over NetBIOS names if using SMB.
  3. Import the Music Library by doing the following: Same idea as videos, but using the steps for adding music to the library. You'll end up with an identical 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.

Adding new XBMC devices to the MySQL setup

Since the database has now been set up on the MySQL server, all you need to do for any additional XBMC devices is add the advancedsettings.xml file. You don't need to do any of the other steps, such as rescanning or reimporting. If it works on one XBMC device then it should work on all of them, as they are basically sharing the same "brain".

If you however used a metadata collector add-on (scraper) that does not ship by default with new installations, such as the Universal Movie Scraper you will not be able to display the media information screen on the new XBMC device. To fix that you need to install the same metadata collector add-on on the new device.

Name tag

An additional <name> tag can be used for both the <videodatabase> and <musicdatabase> entries in advancedsettings.xml file, if you want to change the name of the database. The <name> tag is not required. XBMC will use "MyVideos" and "MyMusic" as database names if the <name> tag is not specified.

You may want to do this if you want to have multiple separate libraries (with different content) on the same MySQL server. For example, if you want to create multiple profiles, each with their own shared library, so that each XBMC device can "log-into" that library. (a kids library, a guest library, etc)

Note: Don't try to merge the video and music databases! You need to use different values in the <name> tag or you'll end up confusing XBMC leading to the library functionality not working at all. In other words, don't use <name>XBMC</name> for both music and videos, but instead use something like <name>XBMC-music</name> and <name>XBMC-video</name>.