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 Well-Known Member

    2,487
    229
    63
    May 31, 2014
    Ratings:
    +390
    Local Time:
    8:59 AM
    Nginx-1.13.x
    MariaDB 10.1.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

    28,935
    6,567
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,747
    Local Time:
    3:59 PM
    Nginx 1.13.x
    MariaDB 5.5
    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 Premium Member Premium Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    7:59 AM
    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.
     
    • Like Like x 1
  4. pamamolf

    pamamolf Well-Known Member

    2,487
    229
    63
    May 31, 2014
    Ratings:
    +390
    Local Time:
    8:59 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Ok thanks :)

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

    RoldanLT Well-Known Member

    3,822
    928
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,256
    Local Time:
    1:59 PM
    1.11
    10.2
    • Informative Informative x 2