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

[megahorst]

i try it this evening, without uninstall 1.3Beta.

• Update MySQL (with copy-paste data folder)
• Update MP to 1.3 RC

I'm quite sure that this will work as a quick solution.
But is the database converted from MyISAM to InnoDB with this approach?
InnoDB is the biggest advantage of MySQL 5.5, 5.6 against 5.1 from my point of view. No more crashed tables after a hard server restart.

Perhaps a more experienced user can correct me ...

 

[azzuro]

it's why i test it !
i think I need use Script : mysql_upgrade
https://dev.mysql.com/doc/refman/5.5/en/mysql-upgrade.html

But, Manual for 5.6 seem very easy compared to 5.5
https://dev.mysql.com/doc/refman/5.6/en/installing.html

 

[megahorst]

Ok, if this works properly it is a lot easier as my approach.
But how do you tell the tv-server where the new database is?
Is it your plan to edit the gentle.config, or will you also use the install option with the existing database?

 

[azzuro]

the bug with Deploytool, is (i remember) search if MySQL 5.1 is installed, if not, reinstalling it ! too bad !!!!

i can try : 2 methods
1st : Copy-paste

• Stop Tvservice + Mysqlservice
• install Mysql 5.6
• copy-paste Data folder
• execute mysql_upgrade
• Unintall MySQL 5.1 ?
• start Mysql (verify with workbench, right user)
• Verify gentle.config (directory folder)
• Start Tv serveur config, and try to connect to DB
• If DB connect Succes, update to 1.3 RC

If DeployTool need to install MySQL 5.1 in default mode. switch to custom with "choose database"

2nd : Clean install (as you Megahorst)

• Backup / or not with BackupSetting plugin
• Stop Tvservice + Mysqlservice
• Uninstall MP Tvserveur only (MP don't use Mysql, right ?)
• Uninstall MySQL 5.1
• Clean MySQL folder
• install Mysql 5.6
• Config Wizard MySQL for install service
• WorkBench for verify User Right
• Install MP with "choose Local DB"
• Verify connection / gentle.config
• Restore Backup With Backupsetting plugin

 

[azzuro]

Tested method :
1st : Copy-paste

• Stop Tvservice + Mysqlservice
• Unintall MySQL 5.1
• install Mysql 5.6

set root + password,
Set Mysql as Standard Services, if you have error on setup, verify in Services.msc MySQL services is Standard services not ""WINDOWS-NT authority ..."

• copy-paste Data folder
• start Mysql
• Start TVserver, if connection failed go to Workbench
• (verify with workbench, right user) as Wiki replace "1::" by "%"
• Verify gentle.config (directory folder)
• execute mysql_upgrade.exe
• Start Tv serveur config, and try to connect to DB
• If DB connect Succes, update to 1.3 RC

 

[azzuro]

but is not updated to InnoDB, i think how can i check this ?

 

[megahorst]

You could try this: http://stackoverflow.com/questions/4240977/changing-table-engine-in-mysql

 

[Paranoid Delusion]

Open workbench\preferences

 

[azzuro]

Post 1 update .

 

[powermarcel10]

So MP is still including an old version of MySQL in the installation? May I ask why?

I've never looked into this as everything is working fine here, but I thought that we always included the newest version of MySQL in our installation..