So I have just set this up, and I have not tested it thoroughly yet, but I wanted to get it down on paper so I don't forget. As with some of my other posts this is the merging of other peoples work and findings.
NOTE THIS IS FOR A FULL INSTALL OF NAS4FREE
For MySQL setup on NAS4Free I followed this guide:
And for XBMC setup I followed this guide:
Here is all that information put into a single guide:
Installing and Setting Up MySQL
Create a directory to store MySQL data files, in my case I create a sub-directory in /mnt/data/db/mysql to store database files.
# mkdir -p /mnt/data/db/mysql
where /data - is Mount point name. Provide full rights to this location:
# chmod 777 /mnt/data/db/mysql
By default the MySQL server on NAS4Free stores database files in /var/db/mysql which does not exist at this point, so let's make a symbolic link in that directory:
Create the group and user 'mysql' using the NAS4Free WebGUI, it is important because NAS4Free will forget about the users created on command line after reboot.
Execute the following command to create default databases and tables, and upgrade:
# cd /usr/local/bin
# chown -R mysql:mysql /mnt/data/db/mysql/
Add mysql_enable=”Yes” into /etc/rc.conf. GUI is preferable to make this change (select System | Advanced | rc.conf),
advancedsettings.xml configuration found in the following location:
and should look like this:
One of the first changes you’ll want to make, on your XBMC systems, is to alter what XBMC does in response to you pressing play on a file. By default XBMC simply plays the file from the beginning. Since we now have an XBMC system that remembers our place across multiple machines, we want XBMC to prompt us.
Navigate to Settings | File Lists and set the Default select action to Choose. We want XBMC to ask us what to do when we’re opening a file instead of automatically playing it from the start.
As a final note, specifically with Openelec and Raspberry Pi, although Openelec suggest this for WiFi boxes, set Wait for network before starting XBMC under Openelec addon settings, network.
Updates from lindsay added: http://forums.nas4free.org/viewtopic.php?f=71&t=6026&p=33121#p33119
Additional updates from lindsay:
Optimizing the DB using a cron, I used the following command to test before making the cron:
# mysqlcheck -os -u xbmc -pxbmc --all-databases