home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Area 51 - Testing Area
Update MySQL 5.1 to latest 5.6 version
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="megahorst" data-source="post: 985142" data-attributes="member: 22213"><p></p><p> </p><p><span style="font-family: 'arial'">At least my howto in this thread is a little bit outdated.</span></p><p><span style="font-family: 'arial'">After writing it I have mentioned some things in my self created 5.6 DB that did not fit the needs.</span></p><p><span style="font-family: 'arial'">All the tables were stored as <span style="font-size: 11px"><span style="color: #424242">MyISAM tables. I was able to change the engine to InnoDb for all table but two tables.</span></span></span></p><p><span style="font-family: 'arial'"><span style="font-size: 11px"><span style="color: #424242">I was not able to alter the tables "</span></span><span style="font-size: 12px">recording" and "schedule" to use the InnoDb </span>engine<span style="font-size: 12px">.</span></span></p><p> </p><p><span style="font-family: 'arial'"><span style="font-size: 12px">It always ended with:</span></span></p><p><span style="font-family: 'arial'"><span style="color: #424242">alter table `mptvdb`.`recording` engine=innodb Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.031 sec</span></span></p><p> </p><p><span style="font-family: 'arial'"><span style="color: #424242">At least I did a fresh install of sebastiiis build. Within this all the tables are correct.</span></span></p><p> </p><p><span style="font-family: 'arial'"><span style="color: #424242">I think that converting the tables from a 5.1 to a 5.6 Db together with the change of the engine while updating MePo to a new version is the challenge here. All tables have to be checked after the installer has updated the versions.</span></span></p><p> </p><p><span style="font-family: 'arial'"><span style="color: #424242">Updating should be a testcase here in this Area51 thread.</span></span></p><p> </p><p><span style="font-family: 'arial'"><span style="font-family: 'arial'">If nessary I can provide a short manual how to check the tables in the MySQL workbench.</span></span></p></blockquote><p></p>
[QUOTE="megahorst, post: 985142, member: 22213"] [FONT=arial][/FONT] [FONT=arial]At least my howto in this thread is a little bit outdated.[/FONT] [FONT=arial]After writing it I have mentioned some things in my self created 5.6 DB that did not fit the needs.[/FONT] [FONT=arial]All the tables were stored as [SIZE=11px][COLOR=#424242]MyISAM tables. I was able to change the engine to InnoDb for all table but two tables.[/COLOR][/SIZE][/FONT] [FONT=arial][SIZE=11px][COLOR=#424242]I was not able to alter the tables "[/COLOR][/SIZE][SIZE=3]recording" and "schedule" to use the InnoDb [/SIZE]engine[SIZE=3].[/SIZE][/FONT] [FONT=arial][SIZE=3]It always ended with:[/SIZE][/FONT] [FONT=arial][COLOR=#424242]alter table `mptvdb`.`recording` engine=innodb Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.031 sec[/COLOR][/FONT] [FONT=arial][COLOR=#424242]At least I did a fresh install of sebastiiis build. Within this all the tables are correct.[/COLOR][/FONT] [FONT=arial][COLOR=#424242]I think that converting the tables from a 5.1 to a 5.6 Db together with the change of the engine while updating MePo to a new version is the challenge here. All tables have to be checked after the installer has updated the versions.[/COLOR][/FONT] [FONT=arial][COLOR=#424242]Updating should be a testcase here in this Area51 thread.[/COLOR][/FONT] [FONT=arial][FONT=arial]If nessary I can provide a short manual how to check the tables in the MySQL workbench.[/FONT][/FONT] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Area 51 - Testing Area
Update MySQL 5.1 to latest 5.6 version
Contact us
RSS
Top
Bottom