Want more timely Centmin Mod News Updates?
Become a Member

Addon that will convert automate MyISAM to InnoDB

Discussion in 'Feature Requests & Suggestions' started by pamamolf, Sep 16, 2016.

  1. pamamolf

    pamamolf Premium Member Premium Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    3:32 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    Hi :)

    It will be great if we can have an addon for converting easy all MyISAM tables from a specific DB to InnoDB :)


    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    10:32 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Unfortunately, such conversions need the user to understand the differences, issues and gotchas of InnoDB vs MyISAM as not all tables can easily be converted or should be converted depending on the the table structure. This is where experience with MySQL comes in.
     
  3. SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    2:32 PM
    Nginx:1.11
    MariaDB-10
    I use HeidiSQL on windows if I don't want to use command line from linux. Change or convert tables is also possible with that tool. I use it with a SSH tunnel via my SSH terminal.
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    3:32 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    Ok thanks :)

    I prefer pure ssh for such tasks ......
     
  5. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    8:32 PM
    Mainline
    10.2