HOW-TO:Share libraries using MySQL/Advanced notes
Share libraries w/MySQL, guide:
For a full listing of the advancedsettings.xml parameters, see advancedsettings.xml#<musicdatabase>/<videodatabase>
If your operating system supports symlinks, you can instead use a symlink which does not require editing the advancedsettings.xml. Here's how:
Assuming you have all of the share permissions correct, you can just REPLACE your thumbnails folder on all of the machines except the HOST machine with a symlink.
Here is an example for XBMC users on Windows 7:
Open an elevated command prompt (run as administrator) and then type in:
mklink /D Thumbnails \\HTPC\Users\User_name\AppData\Roaming\XBMC\userdata\Thumbnails
Obviously, you need to adjust the paths for YOUR specific machine(s) or this won't work. Make sure you can reach the shared thumbnail directory through Explorer on each machine. If you can't, you have a permissions problem.
No further settings need to be adjusted, every machine that you do this on will essentially think it is using it's own thumbnails directory, but will in fact be using the HOST machines thumbnail directory. You do not HAVE to use the actual thumbnail directory of an existing XBMC installation as in the example code above. You could, for instance, use a neutral share and then create the symlink on the thumbnails directory for ALL of your machines.
If you were previously using the path substitution method, make sure you remove the path substitution from all machines that you use the symlink on.
3 MySQL speed-up tweaks
From: MySQL speed-up tweaks for XBMC. For v11 (Eden) only the first two tweaks are necessary. See Comments for more information.
3.1 In advancedsettings.xml:
Use the IP address and NOT the hostname of your MySQL server
3.2 In my.ini:
(add to mysqld section) skip-name-resolve
4 Name tag
<name> tag can be used for both the video and music entries in advancedsettings.xml if you want to change the name of the database.
The name tag is not required (XBMC will use a default "MyVideos" and "MyMusic" DB name) and it is recommended to not include it if you only need one library, as some users have reported problems/bugs when it was included.
The tag is only needed if you want to have separate databases on the same MySQL server, like for more than one shared library. For example, if you want to create multiple profiles, each with their own shared library, so that each XBMC device can "log-into" that library.