Reply to thread

Message

From time to time I have the problem that my htpc hangs and I have to switch it off. In these cases the MySQL DB often is corrupted. I have understood, that the InnoDB backend does not does not get corrupted in these cases.

I have planned this:
do a backup with huhas Backup plugin
remove 1.30 beta completely
install MySQL 5.6
have a look how to switch from MyISAM to InnoDB
install 1.30RC and choose the option "I do already have a database-server"
hope that MePo installer creates the MePo db with InnoDB under 5.6 environment
restore my backup
hope everything works as before
Do you think that this will work?

<blockquote data-quote="megahorst" data-source="post: 963861" data-attributes="member: 22213">From time to time I have the problem that my htpc hangs and I have to switch it off. In these cases the MySQL DB often is corrupted. I have understood, that the InnoDB backend does not does not get corrupted in these cases.&nbsp;I have planned this:<ul>
<li data-xf-list-type="ul">do a backup with huhas Backup plugin</li>
<li data-xf-list-type="ul">remove 1.30 beta completely</li>
<li data-xf-list-type="ul">install MySQL 5.6</li>
<li data-xf-list-type="ul">have a look how to switch from MyISAM to InnoDB</li>
<li data-xf-list-type="ul">install 1.30RC and choose the option &quot;I do already have a database-server&quot;</li>
<li data-xf-list-type="ul">hope that MePo installer creates the MePo db with InnoDB under 5.6 environment</li>
<li data-xf-list-type="ul">restore my backup</li>
<li data-xf-list-type="ul">hope everything works as before</li>
</ul>Do you think that this will work?</blockquote>

[QUOTE="megahorst, post: 963861, member: 22213"] From time to time I have the problem that my htpc hangs and I have to switch it off. In these cases the MySQL DB often is corrupted. I have understood, that the InnoDB backend does not does not get corrupted in these cases. I have planned this: [LIST] [*]do a backup with huhas Backup plugin [*]remove 1.30 beta completely [*]install MySQL 5.6 [*]have a look how to switch from [SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]MyISAM to [/COLOR][/FONT][/SIZE][SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]InnoDB[/COLOR][/FONT][/SIZE] [*][SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]install 1.30RC and choose the option "I do already have a database-server"[/COLOR][/FONT][/SIZE] [*][SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]hope that MePo installer creates the MePo db with InnoDB under 5.6 environment[/COLOR][/FONT][/SIZE] [*][SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]restore my backup[/COLOR][/FONT][/SIZE] [*][SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]hope everything works as before[/COLOR][/FONT][/SIZE] [/LIST] [SIZE=14px][FONT=Helvetica Neue][COLOR=#222222]Do you think that this will work?[/COLOR][/FONT][/SIZE] [/QUOTE]