Reply to thread

Hi,

After long search, we found 2 methods for update or install MySQL.

This is User Expérience !

 

¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤

1st : Copy-paste (for existing database)

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

set root "root" + password "MediaPortal"

set name of services : "MySQL"

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

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

¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤

2nd: Clean install (backup files is optionnal) 

(by @megahorst)

• do a backup with huhas Backup plugin
  worked without any problems
• remove 1.30 beta + TV-server completely
  worked without any problems
• uninstall MySQL 5.1
   worked without any problems
• install MySQL 5.6
  Here I had some trouble.
  I did not have a running MySQL service at first. I had to reinstall MySQL. 
  Than the service was there but not up and running. The MySQL installer inserted a "WINDOWS-NT authority ..." username. I have changed this to local system user. Than the service started.
  No trouble with the MySQL-connection at this point.
  At this point it does not make sense to go ahead without running MySQL-service or not working connection.
   Perhaps a more experienced MySQL user can give some hints here how to avoid errors.
• have a look how to switch from MyISAM to InnoDBnothing to do here
• install 1.30RC and choose the option "I do already have a database-server"
  Here I had some trouble again.
  During installation I was asked for the database connection attributes. The installer did not accept 127.0.0.1 or localhost as address of the server that hosts the database. It always said "give propper IP or hostname"
   At this point I had to 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.
   After this the MePo installer created all MePo tables in the MySQL 5.6 DB.
• restore my backup
   I had a little problem here also. After the restore all TV-channels now have channel number 1000 (or 10000?)
  @huha: Are you aware of this?
• hope everything works as before
   I did a quick check last evening. So far no shop stoppers until now. I will do some regression tests the next evenings and check the logs for errors.

¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤

For update to InnoDB, 

link to post in thread :

• With WorkBench
• With Command line

 

Thanks to @Paranoid Delusion for helping ...