Reply to thread

Message

Hi,

here is my solution for change mysql 5.1 to 5.6 and change the mptvdb database to innodb.

FOR TEST ONLY!

extract the mp_change from mysql 5.1 to 5.6.zip
run the backup_mptvdb.bat
uninstall mysql 5.1
install mysql-5.6.10-win32.msi
open the c:\mptvdb.sql with notepade and replace MyISAM texts to InnoDB
save and exit
run the restore_mptvdb.bat

The mysqld will start default paramaterest, so it needs some tunning!

<blockquote data-quote="regeszter" data-source="post: 974578" data-attributes="member: 15874">Hi,&nbsp;here is my solution for change mysql 5.1 to 5.6 and change the mptvdb database to innodb.&nbsp;FOR TEST ONLY!&nbsp;<ol>
<li data-xf-list-type="ol">extract the <a href="https://forum.team-mediaportal.com/attachments/mp_change-from-mysql-5-1-to-5-6-zip.123853/?temp_hash=5ff46aeed475838d1fbf9bf088bf9e9a" target="_blank">mp_change from mysql 5.1 to 5.6.zip</a></li>
<li data-xf-list-type="ol">run the backup_mptvdb.bat</li>
<li data-xf-list-type="ol">uninstall mysql 5.1</li>
<li data-xf-list-type="ol">install mysql-5.6.10-win32.msi</li>
<li data-xf-list-type="ol">open the c:\mptvdb.sql with notepade and replace MyISAM texts to InnoDB 
save and exit</li>
<li data-xf-list-type="ol">run the restore_mptvdb.bat</li>
</ol>The mysqld will start default paramaterest, so it needs some tunning!</blockquote>

[QUOTE="regeszter, post: 974578, member: 15874"] Hi, here is my solution for change mysql 5.1 to 5.6 and change the mptvdb database to innodb. [B]FOR TEST ONLY![/B] [LIST=1] [*]extract the [URL='https://forum.team-mediaportal.com/attachments/mp_change-from-mysql-5-1-to-5-6-zip.123853/?temp_hash=5ff46aeed475838d1fbf9bf088bf9e9a']mp_change from mysql 5.1 to 5.6.zip[/URL] [*]run the[B] backup_mptvdb.bat[/B] [*]uninstall mysql 5.1 [*]install [B]mysql-5.6.10-win32.msi[/B] [*]open the [B]c:\mptvdb.sql[/B] with notepade and replace MyISAM texts to InnoDB save and exit [*]run the [B]restore_mptvdb.b[/B][B]at[/B] [/LIST] The mysqld will start default paramaterest, so it needs some tunning! [/QUOTE]