Update MySQL 5.1 to latest 5.6 version (3 Viewers)

[regeszter]

It works!!!

 

[catavolt]

Hi Seb, just tested the new installer from 1st post: Congrats - works perfect
MySQL 5.6 installed w/o problems now
THX

 

[Arturas1976]

So still do not understand clearly - is it tested and I can do 1.5 final with MySQL 5.1 migration to 1.5 final MySQL 5.6 all with the installer in #1 post?

And will this be upgradable to later 1.6 Pre standard installer? Because I see this is special build.

 

[elliottmc]

So still do not understand clearly - is it tested and I can do 1.5 final with MySQL 5.1 migration to 1.5 final MySQL 5.6 all with the installer in #1 post?

And will this be upgradable to later 1.6 Pre standard installer? Because I see this is special build.

That is the plan, but it isn't tested. That is the whole point of area 51.

 

[regeszter]

Hi Seb,

your updater does not convert the tables to innodb. Do you plan include this feature to installer? It seems to easy.

 

[Sebastiii]

Hi,

For memory, it should convert it or maybe only on fresh installation, i'm not sure now.
For log commit, it seems to only update to INNODB on fresh db but keep MyISAM for old db.
I think i do it that way because i backup all db from 51 to restore on 56 and the Db name for TVSerser is not always 'MyTvDb' name.
So it's surely possible to convert current Db but we need to know what is the used current Db because maybe not all Db can work with INNODB.

If you have a solution i will happy to apply it on branch

 

[regeszter]

Some months ago I could convert the tables to innodb with the following method:

1. take a bakcup with mysqldump
2. replace all myisam text to innodb in the dumpfile
3. restore the dumpfile

It worked in my test system.

You can read the db name from Gentle.config.

 

[megahorst]

If you have a solution

Have you tried to convert with "ALTER table" SQL commands?

That has worked for me.

 

[Vasilich]

i attached script with ALTER there https://forum.team-mediaportal.com/threads/use-innodb-as-mysql-engine.114397/page-4#post-941725 (in case anyone wants to test this) - that was proved as working by many people

 

[Arturas1976]

i attached script with ALTER there https://forum.team-mediaportal.com/threads/use-innodb-as-mysql-engine.114397/page-4#post-941725 (in case anyone wants to test this) - that was proved as working by many people

PERMISSIONS