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

See also: Profiles

Portable devices

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:

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

<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).