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

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

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

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