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: 963861" data-attributes="member: 22213"><p>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.</p><p> </p><p>I have planned this:</p><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 <span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">MyISAM to </span></span></span><span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">InnoDB</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">install 1.30RC and choose the option "I do already have a database-server"</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">hope that MePo installer creates the MePo db with InnoDB under 5.6 environment</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">restore my backup</span></span></span></li> <li data-xf-list-type="ul"><span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">hope everything works as before</span></span></span></li> </ul><p><span style="font-size: 14px"><span style="font-family: 'Helvetica Neue'"><span style="color: #222222">Do you think that this will work?</span></span></span></p></blockquote><p></p>
[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]
Insert quotes…
Verification
Post reply
Forums
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
Contact us
RSS
Top
Bottom