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 using a central database and one for local use (while travelling).

Create profiles

Configure the Master User profile:

• Open the Profile settings
• Modify the Master User profile
• Rename the profile, for example "Portable"

Configure the Second profile:

• Create a new profile
• Enter a name for the second profile, for example "Home"
• Accept the default profile path
• Select "Separate" for "Media info" and "Media sources"

• Enable the login screen to select a profile on startup

See Profiles for more information about the profile feature.

Configure the Home (or Master) profile

Create a new file "advancedsettings.xml" in the default userdata directory:

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

See Setting up XMBC for more information.

Configure the Travelling profile

Restart XBMC and select the Home profile. This creates the profile directory. Then exit XBMC. Configure the Travelling user profile, using a local database. Create a new file: "advancedsettings.xml" in the userdata/profiles/Travelling directory.

<advancedsettings>

<musicdatabase>
  <type>sqlite3</type>
  <host>/var/mobile/Library/Preferences/XBMC/userdata/Database</host>
  <name>MyMusic7</name>
</musicdatabase>

<videodatabase>
  <type>sqlite3</type>
  <host>/var/mobile/Library/Preferences/XBMC/userdata/Database</host>
  <name>/MyVideos34</name>
</videodatabase>

</advancedsettings>

Notes

The first profile must be the MySQL database. The second profile can be used for local use (while travelling). This is because XBMC reads both the master advancedsettings.xml and the profile advancedsettings.xml. This confuses the MySQL profile.

Source:

• forum:92807- Roaming Profiles