Talk:MySQL: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
(No difference)

Revision as of 22:21, 4 February 2012

NAS how-to link dump

Dumping some urls that might be usable or be a base for how-to's on mysql on NAS's. -- Ned Scott 04:37, 15 November 2011 (EST)

Other useful links

Some more links to look into. -- Ned Scott 20:55, 15 November 2011 (EST)

A couple of comments

Ubuntu users can install MySQL from official Ubuntu repos using apt-get: https://help.ubuntu.com/10.04/serverguide/C/mysql.html

Also, the top of the article has a note mentioning that the latest pre-Eden nightly is required. What specific steps in the article does this apply to, and are there alternative steps applicable to the latest stable release (Dharma 10.1 at the time of this writing)?

Lastly, the scottbrant.net/?p=495 link in the article is not working for me.

Update: I also got access denied errors in the MySQL log while trying to import my XBMC database into it. I think there's a missing step in the article for setting the MySQL 'xbmc' user password. The MythTV wiki has some troubleshooting info on setting passwords that helped: http://www.mythtv.org/wiki/Category:MySQL

--HunterZ 14:42, 11 December 2011 (EST)

Added your links. Eventually we'll have a more general MySQL page for troubleshooting and more advanced setups, but I still put in the mythtv link in the "see also" section for the time being. "CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';" should create the password. The password is what IDENTIFIED BY sets.
Pathsub for thumbs requires pre-Eden, but most of the MySQL setup will still work for Dharma, but you might need to manually create the "xbmc_video" and "xbmc_music" databases (Eden will create databases if missing).
The scottbrant.net link has now been replaced with a link to http://xbmcstuff.bossanova808.net/2011/03/summary-of-xbmc-mysql-database.html?m=1 which has more settings and further discussion on speeding up mysql.
Thanks for the links and let us know if you have any other feedback/ideas/whatever! -- Ned Scott 22:52, 11 December 2011 (EST)


Someone should make a note that the Pre-Eden builds do NOT like it if you create the xbmc_video and xbmc_music databases in advance.

Add them to your advancedsettings.xml but DO NOT CREATE them when installing and configuring MySql or your initial set up will fail. If you have already created them, or you are upgrading from an earlier version of XBMC that did not have this problem, just use a DIFFERENT database name in your advancedsettings.xml, or DROP the two fresh databases if you are installing from scratch.
If upgrading from an earlier version, export your library before upgrading, then import it once everything is set up again on the new version. I just spent about 10 hours tracking down this elusive piece of information, so hopefully this helps someone else. I know for sure that this affects all nightlies from 12/9/2011 and on, could very easily be an issue going back for months as far as I know. This may change, so try the "old" way first and if it fails (check your log) then simply drop those two databases (unless upgrading and you don't have a backup already!)
As I just registered here for the purpose of sharing this info, I put it here rather than in the actual guide as I am not entirely familiar with the rules yet and don't want to step on any toes right off the bat! J114 02:32, 15 December 2011 (EST)
will put a warning note in there, but hopefully that's a bug that will be fixed by Eden's release. -- Ned Scott 02:37, 15 December 2011 (EST)