2010-11-18, 14:34
Since XBMC SVN r28142 MySQL has been supported for hosting the library database so multiple instances of XBMC can connect to and share the same libraray. The original MySQL thread has become a bit large and there are a lot of users having the same issues over and over. With a lot of the info now buried throughout the thread I thought I’d write up a guide on how to set up XBMC to use a MySQL database and guide through some of the more common troubleshooting steps. I’ve meant to do this for a while so apologies for it taking a while to get up and thanks to all those who contributed to the knowledge contained in this, especially Charrua who has helped a lot of people throughout the original thread.
A lot of the guide may seem obvious to a lot of users but I’ve tried to write it from the aspect of needing no knowledge of XBMC or MySQL. That said if using this remember it’s a new feature which is still developing along with the new database ideas and is intended for people who are fairly confident with configuring it hence why it’s only available from advanced settings. The guide will be written primarily from a windows viewpoint, as that is what I’m using, but will try to keep it fairly generic in description so most can follow it. If anyone notices anything missing anyone wants amendments made to the posts just let me know and I’ll try to keep this up to date so most of the info is in one place.
I’m at work so can’t go through all the steps at the moment but will try to make it as complete as possible over the next few days and continue to update as I can to get all the info in there. If anyone is unable to get it working following these steps post details of your problem with a full debug log and someone
*****edit*****
apologies for my lack of input on this been busy elsewhere but Krazypoloc pm'd me re: additional indexes to improve the performance of your mysql db see his post http://forum.xbmc.org/showpost.php?p=746...stcount=90 for details and I'll update post 5 if anyone has anything that should be added let me know.
A lot of the guide may seem obvious to a lot of users but I’ve tried to write it from the aspect of needing no knowledge of XBMC or MySQL. That said if using this remember it’s a new feature which is still developing along with the new database ideas and is intended for people who are fairly confident with configuring it hence why it’s only available from advanced settings. The guide will be written primarily from a windows viewpoint, as that is what I’m using, but will try to keep it fairly generic in description so most can follow it. If anyone notices anything missing anyone wants amendments made to the posts just let me know and I’ll try to keep this up to date so most of the info is in one place.
I’m at work so can’t go through all the steps at the moment but will try to make it as complete as possible over the next few days and continue to update as I can to get all the info in there. If anyone is unable to get it working following these steps post details of your problem with a full debug log and someone
*****edit*****
apologies for my lack of input on this been busy elsewhere but Krazypoloc pm'd me re: additional indexes to improve the performance of your mysql db see his post http://forum.xbmc.org/showpost.php?p=746...stcount=90 for details and I'll update post 5 if anyone has anything that should be added let me know.