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
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
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: 964125" data-attributes="member: 22213"><p>After a long evening I got it working.</p><p>MePo 1.30 RC running with MySQL 5.6 TV-Server Database.</p><p> </p><p>I did it this way:</p><ul> <li data-xf-list-type="ul"><span style="font-size: 11px"><span style="color: #424242"><span style="font-size: 12px"><strong>do a backup with huhas Backup plugin</strong></span><br /> <span style="font-size: 12px">worked without any problems</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 11px"><span style="color: #424242"><span style="font-size: 12px"><strong>remove 1.30 beta + TV-server completely</strong></span><br /> <span style="font-size: 12px">worked without any problems</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 11px"><span style="color: #424242"><strong><span style="font-size: 12px">uninstall MySQL 5.1<br /> worked without any problems</span></strong></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 12px"><strong>install MySQL 5.6</strong></span><br /> <span style="font-size: 12px">Here I had some trouble.</span><br /> <span style="font-size: 12px">I did not have a running MySQL service at first. I had to reinstall MySQL. </span><br /> <span style="font-size: 12px">Than the service was there but not up and running. The MySQL installer inserted a "WINDOWS-NT authority ..." username. I have changed this to local system user. Than the service started.</span><br /> <span style="font-size: 12px"><span style="color: #424242"><span style="font-size: 12px">No trouble with the MySQL-connection at this point.</span></span></span><br /> <span style="font-size: 12px"><span style="color: #424242">At this point it does not make sense to go ahead without running MySQL-service or not working connection.<br /> Perhaps a more experienced MySQL user can give some hints here how to avoid errors.</span></span></li> <li data-xf-list-type="ul"><span style="font-size: 11px"><span style="color: #424242"><span style="font-size: 12px"><strong>have a look how to switch from MyISAM to InnoDB</strong>nothing to do here</span></span></span></li> <li data-xf-list-type="ul"><strong><span style="font-size: 12px"><span style="color: #424242">install 1.30RC and choose the option "I do already have a database-server"</span></span></strong><br /> <span style="font-size: 12px"><span style="color: #424242"><span style="font-size: 12px">Here I had some trouble again.</span></span></span><br /> <span style="font-size: 12px"><span style="color: #424242"><span style="font-size: 12px">During installation I was asked for the database connection attributes. The installer did not accept 127.0.0.1 or localhost as address of the server that hosts the database. It always said "give propper IP or hostname"<br /> At this point I had to go back to MySQL workbench and had to add a user/hostname combination "root / <full hostname of htpc>" and to give DBA rights to this user.<br /> After this the MePo installer created all MePo tables in the MySQL 5.6 DB.</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 11px"><span style="color: #424242"><span style="font-size: 12px"><strong>restore my backup</strong><br /> I had a little problem here also. After the restore all TV-channels now have channel number 1000 (or 10000?)<br /> @<a href="https://forum.team-mediaportal.com/members/huha.63847/" target="_blank">huha</a>: Are you aware of this?</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 11px"><span style="color: #424242"><span style="font-size: 12px"><strong>hope everything works as before</strong><br /> I did a quick check last evening. So far no shop stoppers until now. I will do some regression tests the next evenings and check the logs for errors.</span></span></span></li> </ul></blockquote><p></p>
[QUOTE="megahorst, post: 964125, member: 22213"] After a long evening I got it working. MePo 1.30 RC running with MySQL 5.6 TV-Server Database. I did it this way: [LIST] [*][SIZE=11px][COLOR=#424242][SIZE=3][B]do a backup with huhas Backup plugin[/B][/SIZE] [SIZE=3]worked without any problems[/SIZE][/COLOR][/SIZE] [*][SIZE=11px][COLOR=#424242][SIZE=3][B]remove 1.30 beta + TV-server completely[/B][/SIZE] [SIZE=3]worked without any problems[/SIZE][/COLOR][/SIZE] [*][SIZE=11px][COLOR=#424242][B][SIZE=3]uninstall MySQL 5.1 worked without any problems[/SIZE][/B][/COLOR][/SIZE] [*][SIZE=3][B]install MySQL 5.6[/B][/SIZE] [SIZE=3]Here I had some trouble.[/SIZE] [SIZE=3]I did not have a running MySQL service at first. I had to reinstall MySQL. [/SIZE] [SIZE=3]Than the service was there but not up and running. The MySQL installer inserted a "WINDOWS-NT authority ..." username. I have changed this to local system user. Than the service started.[/SIZE] [SIZE=3][COLOR=#424242][SIZE=3]No trouble with the MySQL-connection at this point.[/SIZE][/COLOR][/SIZE] [SIZE=3][COLOR=#424242]At this point it does not make sense to go ahead without running MySQL-service or not working connection. Perhaps a more experienced MySQL user can give some hints here how to avoid errors.[/COLOR][/SIZE] [*][SIZE=11px][COLOR=#424242][SIZE=3][B]have a look how to switch from MyISAM to InnoDB[/B]nothing to do here[/SIZE][/COLOR][/SIZE] [*][B][SIZE=3][COLOR=#424242]install 1.30RC and choose the option "I do already have a database-server"[/COLOR][/SIZE][/B] [SIZE=3][COLOR=#424242][SIZE=3]Here I had some trouble again.[/SIZE][/COLOR][/SIZE] [SIZE=3][COLOR=#424242][SIZE=3]During installation I was asked for the database connection attributes. The installer did not accept 127.0.0.1 or localhost as address of the server that hosts the database. It always said "give propper IP or hostname" At this point I had to go back to MySQL workbench and had to add a user/hostname combination "root / <full hostname of htpc>" and to give DBA rights to this user. After this the MePo installer created all MePo tables in the MySQL 5.6 DB.[/SIZE][/COLOR][/SIZE] [*][SIZE=11px][COLOR=#424242][SIZE=3][B]restore my backup[/B] I had a little problem here also. After the restore all TV-channels now have channel number 1000 (or 10000?) @[URL='https://forum.team-mediaportal.com/members/huha.63847/']huha[/URL]: Are you aware of this?[/SIZE][/COLOR][/SIZE] [*][SIZE=11px][COLOR=#424242][SIZE=3][B]hope everything works as before[/B] I did a quick check last evening. So far no shop stoppers until now. I will do some regression tests the next evenings and check the logs for errors.[/SIZE][/COLOR][/SIZE] [/LIST] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
Contact us
RSS
Top
Bottom