Update MySQL 5.1 to latest 5.6 version (2 Viewers)

megahorst

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

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Home Country
    Germany Germany
    no.... :)

    Bild5.png
     

    megahorst

    Super User
  • Team MediaPortal
  • Super User
  • July 8, 2006
    879
    259
    Home Country
    Germany Germany
    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
    Home Country
    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
    Home Country
    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
    Home Country
    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

    Top Bottom