By default, XBMC will use an internal SQLite-based database implementation. However, we would like to get XBMC to use our MySQL database instead. This is done by defining the database in advancedsettings.xml
. We'll cover how to set up advancedsettings.xml
for Raspbmc, but for other platforms, you should consult http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries/Setting_up_XBMC.
The best method for editing the settings file is via Secure Shell (SSH). SSH allows us to run commands on our Raspbmc installation as if we were typing them via a keyboard. The advantage of this is that we do not need to plug in a USB keyboard (which may not be available in spare) into the unit to edit the file.
On Linux and OS X systems, all we need is to open a Terminal and run the following command (substituting the IP address of the Raspberry Pi itself):
As you are connecting to the database for the first time, you are likely to see a message similar...