Update MySQL 5.1 to latest 5.6 version (1 Viewer)

megahorst

Super User
  • Team MediaPortal
  • Super User
  • July 8, 2006
    879
    259
    Germany Germany
    Country flag
    You have to give the full name as host. Hoschi-PC.fritz.box.
    This should do the job.
     

    megahorst

    Super User
  • Team MediaPortal
  • Super User
  • July 8, 2006
    879
    259
    Germany Germany
    Country flag
    I have managesd it like I have described it here:
    https://forum.team-mediaportal.com/threads/how-to-user-exp-update-mysql.116108/page-2#post-964125

    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.
    You have given DBA rights to the new created user?
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    The file seems to be OK. I will test in my test db.

    EDIT:
    After import:

    mysql> SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `T
    ABLE_SCHEMA` = 'mptvdb';
    +--------------------+--------+
    | TABLE_NAME | ENGINE |
    +--------------------+--------+
    | canceledschedule | InnoDB |
    | card | InnoDB |
    | cardgroup | InnoDB |
    | cardgroupmap | InnoDB |
    | channel | InnoDB |
    | channelgroup | InnoDB |
    | channellinkagemap | InnoDB |
    | channelmap | InnoDB |
    | conflict | InnoDB |
    | diseqcmotor | InnoDB |
    | favorite | InnoDB |
    | groupmap | InnoDB |
    | history | InnoDB |
    | keyword | InnoDB |
    | keywordmap | InnoDB |
    | pendingdeletion | InnoDB |
    | personaltvguidemap | InnoDB |
    | program | InnoDB |
    | radiochannelgroup | InnoDB |
    | radiogroupmap | InnoDB |
    | recording | InnoDB |
    | satellite | InnoDB |
    | schedule | InnoDB |
    | server | InnoDB |
    | setting | InnoDB |
    | softwareencoder | InnoDB |
    | timespan | InnoDB |
    | tuningdetail | InnoDB |
    | tvmoviemapping | InnoDB |
    | version | InnoDB |
    +--------------------+--------+
    30 rows in set (0.09 sec)

    Can you re-run the import again?
     
    Last edited:

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Germany Germany
    K thank you. Yes i can do it thirt time. Maybe this was my fault.. I typed that

    SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `T
    ABLE_SCHEMA` = 'mptvdb';
    in my CMD. You add this on start at the line
    Try again and the same result. After the imput line there is no message if was right or wrong.

    I can do what i want, it does not work. I think on this part i import it back to mysql...
     
    Last edited:

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Germany Germany
    So all tables are using now InnoDB engine (make with workbench easily) but 2 can't alter table shedule and records becaus this message...

    Specified key was too long; max key length is 767 bytesSQL

    Here in the forum i have found a info the someone like this

    For what it's worth, i just had the same problem and switching from utf8_general_ci to utf8_unicode_ci solved the problem for me. I do not know why though
    Is this needed utf8_general_ci or can i choose the other one ?

    What we need RAW FORMAT : Dynamic or Compact: When i do a fresh install with M 1.6 and install mysql 5.6 and make a dump of mptvdb.sql there is also RAW Format Dynamic. But around the forums some people talk from Compact Format ? What is right ?
     

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

    OP Similar threads Forum Replies Date
    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
    Neoculture Bulk file name update My TVSeries 6
    Similar threads

























    Top Bottom