Overview

You want update to MySQL 5.6 version ( by yourself or with DeployTool) , and you want update your old Database with MyISAM to InnoDB structure. this how to is made for you, but this is made by user experience !!

many ways how to get there!

First Step : Update MySQL

Update MySQL 5.1.x to 5.6.x

• 3 méthods !

1. Copy-paste (for existing database)
2. Clean install (backup files is optionnal)
3. With DeployTool (recommanded)

1. Copy-paste

As title say, You have already MySQL 5.1 installed and Tvserveur working.

First Step :

• Stop Tvservice and Mysqlservice

(look in task manager : Service Tab and look the name of Mysqlxx.exe )

Open an commande line :

*CMD* 

Use function "NET STOP" for stop Services :

WARNING : TVservice must be stoped the First !!!!

*NET STOP TvService*
*NET STOP mysql\**

*correct the name with the good service name"

• Unintall MySQL 5.1

• Install Mysql 5.6

Download inbstaller  from //www.mysql.fr/downloads/installer/ 

Choose custom installation and select only :

• MySQL server
• Applications / WorkBench

set root "root" + password "MediaPortal"
 

set name of services : "MySQL" instead of "MySQL56"

Set Mysql as Standard Services,

if you have error on setup, verify in Services.msc

MySQL services is set as "Standard services" not ""WINDOWS-NT authority ..."

• copy-paste "MPtvDB"

Copy "MptvDB" folder from ../ProgramData/MySQL51/ to ../ProgramData/MySQL56/

Also in /ProgramFiles(x86)/MySQL51 to /ProgramFiles(x86)/MySQL56

• Start MySQL

start services with same step for Stop Servies but use "NET START" Function.

• Start TVserver,

if connection failed go to Workbench

(verify with workbench, right user) as Wiki replace "1::" by "%"

• execute Upgrade function

Open MySQL 5.6 command line client, and use

mysql_upgrade.exe 

• Start Tv serveur config, and try to connect to DB

If DB connect Succes, update to 1.3 Final

with loging :

root "root"

password "MediaPortal"

1. Clean Folder

 you start from fresh install .or want use backup plugin

• do a backup

with huhas[ Backup plugin|https://www.team-mediaportal.com/extensions/system/backupsettings]
 

• Uninstall Mediaportal

Mediaportal + TV-server completely

• *uninstall MySQL 5.1*

Same step from Copy-Paste step

• install MySQL 5.6

Same step from Copy-Paste step

• install MediaPortal

with deploy Tool and choose the option "I do already have a database-server"
here, if you have trouble for connect to MySQL server, go back to MySQL workbench and had to add a user/hostname combination "root / <full hostname of htpc>" and to give DBA rights to this user.

• Restore my backup

Use Backup Setting for restore your settings.

1. MediaPortal Deploy Tool

install / update Mediaportal with official release for update MySQL to 5.6 and ( not sure) update to InnoDB, in auto mode

Second Step : Switch to InnoDB

Then continue with ...

What's Next

This is what was achieved and what was omitted in this tutorial.

Related

• SQL Server