MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB (5 Viewers)
- Thread starter Sebastiii
- Start date
France
It appears the upgrade works. I have no way of validating the new DB except I removed the left over DB files from the 5.1 install and opened TV-Server Configure..... All my channels were intact
As for the left over DB info
As you can see, each of these are screenshots of Both Data folders and what was inside them.
I don't know if this is what you want to do or not so I am reporting it.
As for the left over DB info
As you can see, each of these are screenshots of Both Data folders and what was inside them.
I don't know if this is what you want to do or not so I am reporting it.
Does the DB upgrade write a log or can it? I could not locate one
I was just going thru my Application Events log and found this from the time the upgrade was happening
Error - Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
Error - Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
- Thread starter
- Moderator
- #17
Seems to solve the issue :
So maybe add this '--skip-grant-tables' when restore but i'm not sure.
Code:
[7 Jan 2011 22:29] Peter Laursen
Will this help:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html
"start the server with the --skip-grant-tables option to cause it to skip the normal grant table checks, then run mysql_upgrade. ... Then stop the server and restart it normally."
Peter
(not a MySQL person)So maybe add this '--skip-grant-tables' when restore but i'm not sure.
Just tried your Setup - steps taken - installed MP 1.5 final (had 1.6 on teh machine before) - run your Setup - installation went straight throw without any issues. Also my rather big JMMServer was migrated to 5.6 (Japanese Media Manager). The only thing i Noticed is that the first install dialog appears two times.
- Thread starter
- Moderator
- #19
Hi,
I have spend all the morning to try to add '--skip-grant-tables', it's tricky because we need to start mysqld.exe (not the service) -> start mysql upgrade etc. -> kill mysqld.exe -> start the service etc.
But in final lol, '--skip-grant-tables' didn't work and in fact the restore/upgrade works
Code:
Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlcheck.exe
Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"
Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306" "--host=localhost"
mptvdb.canceledschedule OK
mptvdb.card OK
mptvdb.cardgroup OK
mptvdb.cardgroupmap OK
mptvdb.channel OK
mptvdb.channelgroup OK
mptvdb.channellinkagemap OK
mptvdb.channelmap OK
mptvdb.conflict OK
mptvdb.diseqcmotor OK
mptvdb.favorite OK
mptvdb.groupmap OK
mptvdb.history OK
mptvdb.keyword OK
mptvdb.keywordmap OK
mptvdb.pendingdeletion OK
mptvdb.personaltvguidemap OK
mptvdb.program OK
mptvdb.radiochannelgroup OK
mptvdb.radiogroupmap OK
mptvdb.recording OK
mptvdb.satellite OK
mptvdb.schedule OK
mptvdb.server OK
mptvdb.setting OK
mptvdb.softwareencoder OK
mptvdb.timespan OK
mptvdb.tuningdetail OK
mptvdb.tvmoviemapping OK
mptvdb.version OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
OKLike we can see : mysql.proc is OK
So we don't have to care about it
So we are good