/ Register

Learn about Centmin Mod LEMP Stack today
Register Now

Addon that will convert automate MyISAM to InnoDB

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

Previous Thread Next Thread
Loading...
  1. Sep 16, 2016 #1
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:14 PM
    Nginx-1.29.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. Sep 16, 2016 #2
    eva2000

    eva2000 Administrator Staff Member

    58,908
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:14 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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. Sep 16, 2016 #3
    SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    3:14 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. Sep 16, 2016 #4
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:14 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Ok thanks :)

    I prefer pure ssh for such tasks ......
     
  5. Sep 17, 2016 #5
    rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    9:14 PM
    Mainline
    10.2
Previous Thread Next Thread
Loading...

.