Update MySQL 5.1 to latest 5.6 version (1 Viewer)

Hawkeye

Portal Pro
January 29, 2005
548
87
Halle (Saale)
Germany Germany
Country flag
In your folder MySQL Server 5.6 you´ll find the file my.ini - there you can verofy whether innodb is used or not:
[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
But that only shows you the default engine not which engine is actually used by the tables.
 

catavolt

Design Group Manager
  • Team MediaPortal
  • August 13, 2007
    12,966
    9,308
    Lanzarote
    Germany Germany
    Country flag
    Hmm, I think that´s the engine used (in the old 5.1 directory the default is set to myisam - which was used there for tv db) ;)
     

    Holzi

    Super Moderator
  • Team MediaPortal
  • April 21, 2010
    7,930
    2,234
    Ba-Wü
    Germany Germany
    Country flag
    So what to check/do else?
    Have you tried to open a command prompt and then navigate to your MySQL bin folder (cd C:\Program Files\MySQL\MySQL Server 5.6\bin) and type: mysql -u root -p

    You will get asked for a password, by default it is: MediaPortal (case sensitive)

    Once you have done that type: SHOW ENGINES;

    INNODB should be the default engine in your case.

    Attached screenshot (with MyISAM as default engine):
    1.png
     

    Arturas1976

    MP Donator
  • Premium Supporter
  • January 5, 2008
    246
    40
    Vilnius
    Lithuania Lithuania
    I repeat - yes, default is Innodb. What else could be?

    I did uninstall MySQL 5.1 and MP, then made all new installation with 5.6 and then got back the backup.
    May be there is some stuff that is not talking well? But anyway I started having such behaviour on 5.1 also.
     
    Last edited:

    Hawkeye

    Portal Pro
    January 29, 2005
    548
    87
    Halle (Saale)
    Germany Germany
    Country flag
    Once again: it's not important which engine is set as default but which one is used by the tables. And that depends on how you restored from backup. If only the data is inserted (SQL command INSERT) there should be no problem with the table type. But if the tables are restored complete (SQL command CREATE) the engine could be set to MyISAM by the query.

    To cut a long story short, if I understand you right you checked the tables with workbench and all are using InnoDB, right? So that should not be the problem.
     

    Arturas1976

    MP Donator
  • Premium Supporter
  • January 5, 2008
    246
    40
    Vilnius
    Lithuania Lithuania
    Workbench shows tables uses Innodb.

    So the problem is not here. The backup was restored by Backup plugin, I do not know how it works.

    Can anyone look at the logs and tell why the connection to db is refused?
     

    Vasilich

    Test Group
  • Team MediaPortal
  • August 30, 2009
    3,393
    1,170
    Germany, Mayence
    Russian Federation Russian Federation
    Country flag
    [2013-10-17 07:04:03,492] [Log ] [DVB EPG timer] [ERROR] - Exception :confused:ystem.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 192.168.0.151:31456
    Do you have any firewall running on 192.168.0.151? or what else can deny socket connecting?
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    A MediaPortal crash (and restart) on LiveTV after Windows Update (Sep 2020) driver update for Intel HD Graphics 4600 General Support 0
    M.Hulot After Update 1.25 internal blu-ray-player doesn't work General Support 8
    M.Hulot Interner Blu-ray-Player spielt nach Update auf 1.25 keine Discs mehr ab Allgemeines Supportforum 2
    E retaining Watch Status when updating? Newcomers Forum 1
    J Update .NET framework? Improvement Suggestions 9
    G Update von MediaPortal Installationsprobleme? 0
    morpheus_xx [Evaluate] Update to VS 2019? MediaPortal 2 4
    Golf4 Nach Windows-Updates läuft TV-Plugin nicht mehr Allgemeines Support- und Diskussionsforum 0
    B MPEM update list never completes. General Support 0
    JJDoherty Updated DTT frequencies for Ireland... Submit: EPG-Grabbers and tuningdetails 1
    Dark Eyes Updated to Windows 10, now TVServer won't work Installation, configuration support 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    M.Hulot Moving Pictures lässt sich nach Windows-Update nicht mehr öffnen Plugins & Erweiterungen 1
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    k12158 [solved] Kein direkter Wechsel von TV-Kanal zu TV-Kanal mehr nach Update? Allgemeines Support- und Diskussionsforum 16
    ajs Mediaportal update to .Net 4.6.2+ MediaPortal 1 13
    Mr6686 [solved] Titan skin broken since update to 1.23 Installation, configuration support 6
    B TV-Server Auto-Update mptvdb after x hours General Support 0
    Terra LAVFilter Plugin cannot be updated (MP1.23) MediaPortal 1 Plugins 10
    TLD Windows 10 1903 feature update General Support 3
    azzuro [WiP] 5043: Update MP1 to VisualStudio 2019 MediaPortal 1 138
    A Problem Windows 10 64 bit prof. Update auf Version 1903(gelöst) Installationsprobleme? 0
    T No TV after updating Windows 10 to latest Version 1903 / OS build 18362.175 (logs attached) General Support 2
    M [solved] Updated Swedish translation for MP 1.24 Submit: Localization of MediaPortal and DeployTool 0
    framug 1.22.0 BasicHome Editor settings for DefaultWide HD skin not kept when update 1.22 3
    Similar threads

























    Top Bottom