Discover Centmin Mod today
Register Now

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,724
    243
    63
    May 31, 2014
    Ratings:
    +434
    Local Time:
    9:58 PM
    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

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:58 AM
    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:
    8:58 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.
     
    • Like Like x 1
  4. pamamolf

    pamamolf Well-Known Member

    2,724
    243
    63
    May 31, 2014
    Ratings:
    +434
    Local Time:
    9:58 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Ok thanks :)

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

    RoldanLT Well-Known Member

    3,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    2:58 AM
    1.11
    10.2
    • Informative Informative x 2