Update MySQL 5.1 to latest 5.6 version | Page 22

Discussion in 'Area 51 - Testing Area' started by Sebastiii, April 15, 2013.

  1. megahorst
    • Super User

    megahorst Super User

    Joined:
    July 8, 2006
    Messages:
    879
    Likes Received:
    173
    Ratings:
    +272 / 0
    Home Country:
    Germany Germany
    Show System Specs
    You have to give the full name as host. Hoschi-PC.fritz.box.
    This should do the job.


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    Home Country:
    Germany Germany
  4. megahorst
    • Super User

    megahorst Super User

    Joined:
    July 8, 2006
    Messages:
    879
    Likes Received:
    173
    Ratings:
    +272 / 0
    Home Country:
    Germany Germany
    Show System Specs
    My fault ...
    I sholuld have described it in more detail:

    I meant not in the workbench. There % is OK!
    You have to give it as hostname in the connection settings of the MePo Config
     
  5. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    Home Country:
    Germany Germany
  6. megahorst
    • Super User

    megahorst Super User

    Joined:
    July 8, 2006
    Messages:
    879
    Likes Received:
    173
    Ratings:
    +272 / 0
    Home Country:
    Germany Germany
    Show System Specs
    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

    You have given DBA rights to the new created user?
     
  7. MaxMan23
    • Premium Supporter

    MaxMan23 MP Donator

    Joined:
    September 8, 2007
    Messages:
    380
    Likes Received:
    36
    Ratings:
    +45 / 0
    Home Country:
    Germany Germany
    That was it :)

    Thanks to all and a Happy New Year
     
  8. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
  9. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    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: January 3, 2014
    • Like Like x 1
  10. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    K thank you. Yes i can do it thirt time. Maybe this was my fault.. I typed that

    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: January 4, 2014
  11. D3ltoroxp
    • Premium Supporter

    D3ltoroxp MP Donator

    Joined:
    June 1, 2008
    Messages:
    3,308
    Likes Received:
    133
    Gender:
    Male
    Ratings:
    +207 / 9
    Home Country:
    Germany Germany
    Show System Specs
    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

    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 ?
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!