MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB (3 Viewers)

[Sebastiii]

Description of Change

Actually, MySQL 5.6 is only available on clean install.
This branch adds an option to DeployTool (Installer) to perform MySQL5.6 on upgrade (at own risk!).
If something fails, the MySQL5.1 db is not touched

Tickets : https://issues.team-mediaportal.com/browse/MP1-4341
Wiki docs: What's New > 1.8.x > MySQL Upgrade choice
Steps to install and test
Installation
Download the -->> installer <<-- and execute it.

Testing
Upgrade your current 1.6.0 Final installation but before :

You need to have MySQL 5.1 installed by older MP install.
Install with this installer.
Select Upgrade and MySQL page should ask if you want to perform an upgrade.
That's all

Look if all is OK.
Please do not forget to give some feedback (also if there is no bug). Thank you!

Sebastiii

Changelog

Version 1.6.0 v1
Build Based on MP 1.6.0 + master

Version 1.6.0 v2
Only binary based on MP 1.6.0 + master (Should only ask for upgrade MySQL on Singleseat ot TV Master only)

Version 1.6.0 v3
V3 installer should fix MySQL detection and also backup db (detect while debugging).
This is based on MP 1.6.0 + master.

Version 1.6.0 v4
V4 installer display MySQL Upgrade page only if 'Upgrade button is selected and if MySQL 5.1 is installed'
This is based on MP 1.6.0 + master.

Version 1.6.0 v5
V5 installer wiki link should be fixed and migration from MySIAM to Innodb should work too on db from MySQL 5.1.
The migration of db will only active based on MySQL server 5.6.10 (installed by deploytool)
This is based on MP 1.6.0 + master.

Version 1.7.1 v6
Installer based on 1.7.1 hotfix

 

[elliottmc]

Tested on a multiseat client install. It asked if I wanted to update MySQL

Need to check for TV server install first I guess!

 

[Sebastiii]

Ok let's see what happen

 

[elliottmc]

Ok let's see what happen

Can anyone else confirm? I am confident that this happened.

Would be good to get it fixed before further testing if possible.

 

[Sebastiii]

Hi,
I have a bin for testing soon (just deploytool.exe)

 

[Sebastiii]

V2 bin on first post (overwrite original MediaPortal.DeployTool.exe from V1 installer).
Thanks

 

[elliottmc]

V2 bin on first post (overwrite original MediaPortal.DeployTool.exe from V1 installer).
Thanks

That works - doesn't ask to update MySQL on multiseat client. No time to test on server this morning.

Please can you update the branch?

 

[Sebastiii]

Sure

 

[Sebastiii]

Done and i will update first post with new installer

 

[breese]

I just cleared MP1 server/client off my machine along with the new version of MySQL.
I have 1.5.0 Final. Does it install the older version of MySQL? If so I will do a Server only install for testing if that is what you need

I installed 1.5.0 with MySQL 5.1. Doing a channel scan and movie import as a baseline for 1.7.0 upgrade test. This is a server only install