Update MySQL 5.1 to latest 5.6 version (1 Viewer)

[azzuro]

i like to make it, but i don't speak very well english ...

 

[radical]

I do not think this is a disadvantage.
You'll probably be able to describe it much better with simple words and make it more understandable.

 

[megahorst]

@azzuro and @megahorst have made already an how to.

Maybe one of them could publish it in the wiki?

At least my howto in this thread is a little bit outdated.
After writing it I have mentioned some things in my self created 5.6 DB that did not fit the needs.
All the tables were stored as MyISAM tables. I was able to change the engine to InnoDb for all table but two tables.
I was not able to alter the tables "recording" and "schedule" to use the InnoDb engine.

It always ended with:
alter table `mptvdb`.`recording` engine=innodb Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.031 sec

At least I did a fresh install of sebastiiis build. Within this all the tables are correct.

I think that converting the tables from a 5.1 to a 5.6 Db together with the change of the engine while updating MePo to a new version is the challenge here. All tables have to be checked after the installer has updated the versions.

Updating should be a testcase here in this Area51 thread.

If nessary I can provide a short manual how to check the tables in the MySQL workbench.

 

[megahorst]

I've been running with v5.6 for a couple of weeks also. Only thing i noticed is that some checkboxes (from a plugin!) wouldn't stick. If i check it, close config, open config, it's UNchecked again. Will contact plugin developer to see if it's on that side.

I'm also using MySQL 5.6 and this plugin. I will check If I have this issue too. Until now I have not mentioned it.

 

[HomeY]

I'm also using MySQL 5.6 and this plugin. I will check If I have this issue too. Until now I have not mentioned it.

TNX!
I just checked my setup this morning and since i had some issues when i removed the 5.1 install after upgrading to 5.6, i think my dB is also switched to InnoDB. If it work for your on MyISAM, then it might be related to that.

 

[powermarcel10]

I've been running with v5.6 for a couple of weeks also. Only thing i noticed is that some checkboxes (from a plugin!) wouldn't stick. If i check it, close config, open config, it's UNchecked again. Will contact plugin developer to see if it's on that side.

I'm also using MySQL 5.6 and this plugin. I will check If I have this issue too. Until now I have not mentioned it.

Would be nice.. I offered to check it aswell, but I'm not using tvwishlist myself, and I have no idea how it works, so if you want to do it? Thanks!

 

[Hawkeye]

It always ended with:
alter table `mptvdb`.`recording` engine=innodb Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.031 sec

For that matter: did you try to fix this issue like described here?

 

[megahorst]

It always ended with:
alter table `mptvdb`.`recording` engine=innodb Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.031 sec

For that matter: did you try to fix this issue like described here?

No, I have not. It was not clear for me how the key values and the application interact. So I left it as it was and did not change it.

For those who want to check the engine that is used for their tables after an update with MySQL workbench:

1. Start the workbench
2. double klick on "Local MySQL" on the left side of the window
3. In the object browser choose the schema "mptvdb"
4. navigate to the tables
5. right click on a table
6. choose "alter table..."
7. click onto the arrows shown in red circle
8. 
9. see the engine
10. 

It seems not to be possible to change this value with the workbench GUI. You have to do this at the SQL prompt.

But:

If you find any table with MyISAM as engine, you should report this here. @Sebastiii should know this to correct his build

 

[megahorst]

I've been running with v5.6 for a couple of weeks also. Only thing i noticed is that some checkboxes (from a plugin!) wouldn't stick. If i check it, close config, open config, it's UNchecked again. Will contact plugin developer to see if it's on that side.

I'm also using MySQL 5.6 and this plugin. I will check If I have this issue too. Until now I have not mentioned it.

I have checked this issue.
Checking/unchecking of a TV wish is stored when you move to another record after checking/unchecking. I think this was the same with MySQL MyISAM 5.1.
All my tables are stored as InnoDb Tables.

 

[HomeY]

I have checked this issue.
Checking /Unchecking of a TV wish is stored when you move to another record after checking/unchecking. I thing this was the same with MySQL MyISAM 5.1.
All my tables are stored as InnoDb Tables.

TNX for checking this @megahorst And indeed, following your instructions makes it 'stick' again! Never noticed this before.
My tables are also stored as InnoDB.