XBMC will be renamed to Kodi for v14. Read here for more details
Various pages on the wiki might contain old references to "XBMC", but will most often still apply to "Kodi". Find out how you can help here.

MySQL/Upgrading

From Kodi
< MySQL
Revision as of 07:38, 9 March 2012 by Ned Scott (Talk | contribs)

Jump to: navigation, search

Share libraries w/MySQL, guide:

  1. Introduction
  2. Setting up MySQL
  3. Setting up XBMC

Play it super safe; it's best to upgrade by: export your library, delete the old MySQL databases, upgrade to pre-Eden, then reimport the library. You will still need to set up MySQL to let XBMC create databases, as noted below.


When upgrading from XBMC v10 (Dharma) to XBMC v11 (Eden) you may need to make changes to your MySQL server. The user made for the MySQL DB ("XBMC" in most guides) will need access to create new databases. If the user already has that access then you don't need to do anything. If not, you will have to use the following command on your MySQL server:

  • GRANT ALL ON *.* TO 'xbmc';


The latest pre-Eden builds will make a copy of the current DB and upgrade the copy. That way if anything goes wrong in the upgrading you still have an original untouched copy of your DB. BACKUP YOUR DATABASE JUST IN CASE. Also EXPORT your library from your current version before beginning the upgrade process or you may find yourself starting your library from scratch.


Updating your library may take a few minutes, so be sure to give XBMC time to do its thing. Stopping midway will mess up the updated DB.


If your upgrade fails with database errors, you should edit your advancedsettings.xml and remove the lines <name>myvideos</name> and <name>mymusic</name>. They are only needed if you want to use multiple Video or Audio MySQL databases.

Personal tools
Namespaces

Variants
Actions
Navigation
Wiki help
Toolbox