Join the community 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

    3,112
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    9:45 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

    35,611
    7,842
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,089
    Local Time:
    4:45 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    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:
    8:45 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

    3,112
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    9:45 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Ok thanks :)

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

    rdan Premium Member Premium Member

    4,244
    1,033
    113
    May 25, 2014
    Ratings:
    +1,481
    Local Time:
    2:45 AM
    Mainline
    10.2
    • Informative Informative x 2
..