MySQL/Portable devices and profiles

Share libraries w/MySQL, guide: Introduction Setting up MySQL Setting up Kodi Sharing artwork Sync other parts of Kodi Upgrading XBMC/Kodi Portable devices and profiles Advanced notes Backup and restore databases Update paths in MySQL

MySQL

Portable devices and profiles

If you use your device (notebook or mobile iOS device) in multiple situations, you can create multiple profiles. You can use one profile at home, using a central MySQL database and another profile for use when travelling.

First create two profiles. Configure one profile for "local use" (internal HDD only, while traveling, etc) and another for using a central database. You can even make profiles for different wifi networks that have different centralized databases (your home, a friend's home, etc).

Create profiles

Main page: Profiles

1. Configure the Master User profile:
   1. Open the Profile settings
   2. Modify the Master User profile
   3. Rename the profile, for example "Portable"
2. Configure the Second profile:
   1. Create a new profile
   2. Enter a name for the second profile, for example "Home"
   3. Accept the default profile path
   4. Select "Separate" for "Media info" and "Media sources"
3. Enable the login screen to select a profile on startup

Configure the MySQL profile

Create a new file "advancedsettings.xml" in userdata/profiles/<username>/:

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>kodi</user>
        <pass>kodi</pass>
    </videodatabase> 

    <musicdatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>kodi</user>
        <pass>kodi</pass>
    </musicdatabase>
</advancedsettings>

See Setting up Kodi for more information.

Using different MySQL servers per profile

Each profile acts as a different set of Kodi settings, and can have their own advancedsettings.xml file. By setting up either different MySQL servers, or a single MySQL server with different database names, each profile can point to a different MySQL library.

For example:

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <name>Bob</name>
        <port>3306</port>
        <user>kodi</user>
        <pass>kodi</pass>
    </videodatabase> 

    <musicdatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <name>Bob</name>
        <port>3306</port>
        <user>kodi</user>
        <pass>kodi</pass>
    </musicdatabase>
</advancedsettings>

Using the <name> tags this advancedsettings.xml file will point to a database with a "Bob" prefix name, instead of the default "myvideos" or "mymusic" prefix (these are used when the name tag is excluded).