Tools and other software [How To] [User Exp] Update MySQL (2 Viewers)

[azzuro]

How can i look, if my DB have error ?
command line / log ?
because i think i don't have error ...

i have switched to InnoDB from Workbench directly. after copy-paste DB (5.1 to 5.6) as described in #1

For information : on Workstation system
Updated to 1.3 (final test build), select "Use existing DB" in deploy tool, MP ask correctly for connect to DB / and connection is an sucess.
Radio (already scanned) working / No can't test TV on the System ...

 

[Sebastiii]

Updated link with latest GIT Branch : -->> HERE <<--

 

[Sebastiii]

How can i look, if my DB have error ?
command line / log ?
because i think i don't have error ...

I don't know but i use the command line to repair db and all was ok but before latest commit, i have the same error as @megahorst : 'Error Code: 1071. Specified key was too long; max key length is 767 bytes'

 

[megahorst]

@azzuro:
You should try this:

SHOW TABLE STATUS FROM mptvdb;

The output will show you the details off your tables.

@Sebastiii:
I made an error yesterday evening. My mptvdb schema was not propperly dropped. It was still there and the new MySQL 5.6 installation which came with the installation of your build took these files. This leaded to the errors.
This morning I have installed your build from again and know everything is ok.
Is there a need to test the build from today?

 

[Sebastiii]

Thanks
I suppose not then

 

[megahorst]

Ok!

The missing tvmovieprogram table is not part of the original tv-server installation. It is created by the tv-server plugin "TV Movie EPG import++"
So this issue is not an error too.

 

[SkinsFan0521]

i have switch to InnoDB in Workbench directly !
For that

• Open Workbench
• Left Menu (select Edit tables)
• Open mptvdb scheme
• Right click on one table
• select "Alter Table"
• Switch Myisiam -> InnoDB
• Select "Apply" & Close Tables
• Make this for all tables (one by one)

Row_format : Dynamic (not changed)
Character_set : UTF8 default (not changed)
No error message in Workbench

For test : i have scanned DVB-S (2500 channel), i think configuration.exe freeze less compared to 5.1+Mysiam (my HTPC is really slow)
but many channel have 10000 as channel Number.

I know this was from a couple weeks ago, but I'm wondering how you got this to change through Workbench? When I do it, it says "No Changes Detected" and then when I open the table back up in Alter to verify, it still shows as 'MyISAM'

I'd prefer to do it through Workbench if possible, so I'm just wondering what I'm missing.

Thanks!

 

[megahorst]

I know this was from a couple weeks ago, but I'm wondering how you got this to change through Workbench? When I do it, it says "No Changes Detected" and then when I open the table back up in Alter to verify, it still shows as 'MyISAM'

I have noticed the same.
For my only the "Alter Table" statements worked.

see my answer here:

https://forum.team-mediaportal.com/threads/how-to-user-exp-update-mysql.116108/page-4#post-967310

 

[regeszter]

Hi,

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

FOR TEST ONLY!

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

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

 

[megahorst]

In fact, in this branch i didn't do migration of DB in InnoDB, i only backup current 5.1 and restore to 5.6, so the DB stay in MyISAM. But on fresh installation (read no db existing) the new TV DB is configured as InnoDB.

@Sebastiii: I'm using your branch since several weeks now. It is working without any problems. TV-server plugins (TvWisLlist, TV Movie epg import ++) are also working fine with the new database. With the InnoDb as backend I have not seen corrupt tables anymore.

Is it possible to have the new db within the 1.40 release?