2012-03-30, 00:40
Hello,
I have searched the threads high and low and tried everything suggested there and in the Wiki....I need help.
A couple of questions for someone smarter than myself about upgrading and MySQL databases.
I have windows 7 computer that I use as a server. This computer has the MySQL database on it. I have 5 other computers (windows 7) that this computer serves content to. I have been trying to upgrade one of the 5 computers to Eden from Dharma, and I just can't get it to work. Please see this thread: http://forum.xbmc.org/showthread.php?tid=127027
So my first question is: Do I need to do the first upgrade to Eden on the computer that has the MySQL database installed or can it be done on any computer on my network?
My second question has to do with granting privileges to the MySQL db. For some reason, when I try to enter the password into the MySQL command line client, it closes right away so that I can't add "GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';" Now I am doing this using the "Remote Desktop Connection", if that makes a difference? So I am using HeidiSQL to get to my XBMC database. Heidi shows me that all available privileges are checked for "Server Privileges" and "all databases". Can this be done with HeidiSQL rather than the command line client?
My last question for now is concerning this line in the Wiki: 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.
Is this saying that the names of the new XBMC databases do not need to be in the advancedsettings.xml file? So I would not add <name>xbmc_video60</name> and <name>xbmc_music18</name> to the advancedsettings.xml file? Is this true?
Please help.
Thanks,
Mark
I have searched the threads high and low and tried everything suggested there and in the Wiki....I need help.
A couple of questions for someone smarter than myself about upgrading and MySQL databases.
I have windows 7 computer that I use as a server. This computer has the MySQL database on it. I have 5 other computers (windows 7) that this computer serves content to. I have been trying to upgrade one of the 5 computers to Eden from Dharma, and I just can't get it to work. Please see this thread: http://forum.xbmc.org/showthread.php?tid=127027
So my first question is: Do I need to do the first upgrade to Eden on the computer that has the MySQL database installed or can it be done on any computer on my network?
My second question has to do with granting privileges to the MySQL db. For some reason, when I try to enter the password into the MySQL command line client, it closes right away so that I can't add "GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';" Now I am doing this using the "Remote Desktop Connection", if that makes a difference? So I am using HeidiSQL to get to my XBMC database. Heidi shows me that all available privileges are checked for "Server Privileges" and "all databases". Can this be done with HeidiSQL rather than the command line client?
My last question for now is concerning this line in the Wiki: 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.
Is this saying that the names of the new XBMC databases do not need to be in the advancedsettings.xml file? So I would not add <name>xbmc_video60</name> and <name>xbmc_music18</name> to the advancedsettings.xml file? Is this true?
Please help.
Thanks,
Mark