Talk:MySQL: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
>HunterZ
No edit summary
Line 23: Line 23:


--[[User:HunterZ|HunterZ]] 14:42, 11 December 2011 (EST)
--[[User:HunterZ|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.
: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! -- [[User:Ned Scott|Ned Scott]] 22:52, 11 December 2011 (EST)

Revision as of 03:52, 12 December 2011

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.
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)