Update MySQL 5.1 to latest 5.6 version (4 Viewers)

[mrbonsen]

So in theory if we do a clean install of MP, it will install MySQL 5.6 and use InnoDB ? And everything will be great?

yes, I have done so (screen)

update from 1.4 -> 1.5 area51 installer = not clean (mysql 5.1 to 5.6) import/export problems
update from final 1.5 -> 1.5 area51 installer = not clean (mysql 5.1 to 5.6) import/export problems
always small problems, for me as a "layman/beginners" to great risk

EDIT: precise contribution

 

[Sebastiii]

So it doesn't works, I'm not sure to follow you lol​

 

[mrbonsen]

@Sebastiii
wants to say who is not a professional, should the setup of 1.5 from area51 clean install! no update !
sh*** google translator

 

[Arturas1976]

Will the DB installation be fine if I backup all data, uninstall MySQL+MP then install with upper mentioned installer and import backuped data back?

 

[Sebastiii]

Normally yes

 

[Arturas1976]

Not sure that i write it in this thread, but because I use MySQL 5.6 updated with this installer could be somehow valuable.

It seems that my tvdb is somehow corrupting and refusing to connect MP tv client. It happened with MySQL 5.1 also.
It happens if i turn of tv (not shutting down) and turning on again, this also happens if PC wakes. MP TV server works perfect, I can connect from other pc with MP simple client and use tv. But on the same machine it does not. When I reboot PC MySQL says that it cannot connect to db.
After repairing mptvdb it works again. But on next waking or several turn on/turn off MP client stops tv connection.

Could somenone review logs and help?

 

[azzuro]

i think your database is always as MyISAM format, and not InnoDB
the best thing is to download Workbench, and verify your DB format.
or if seb / or an other guys, know the command line for display the format of your DB, without instal workbench.

 

[azzuro]

CD C:\Program Files\MySQL\MySQL Server 5.6\bin
mysqlcheck mptvdb --analyze -a -u root -p
(-u USER -P Password)
try this

 

[Arturas1976]

Hm...output shows all db lines as "Ok" and that's all.[DOUBLEPOST=1381996147][/DOUBLEPOST]Workbench shows that all tables are using InnoDB engine.

 

[catavolt]

In your folder MySQL Server 5.6 you´ll find the file my.ini - there you can verofy whether innodb is used or not:

Spoiler

[client]
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.6/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.6/Data"
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=32M
tmp_table_size=18M
thread_cache_size=4
thread_concurrency=4
myisam_max_sort_file_size=100M
myisam_sort_buffer_size=64M
key_buffer_size=16M
read_buffer_size=2M
read_rnd_buffer_size=16M
sort_buffer_size=2M
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=96M
innodb_log_file_size=50M
innodb_thread_concurrency=8