from ''MyISAM'' to ''InnoDB'' and conversely

[vestacp89]

Hello,

How i can change ''MyISAM'' to ''InnoDB'' ?
and conversely ?

Thanks.

[skurudo]

mysql / phpmyadmin - http://dev.mysql.com/doc/refman/5.6/en/ ... nnodb.html

or magic php scripts (source)

Code: Select all

<?php
    // connect your database here first 
    // 

    // Actual code starts here 

    $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA = 'your_database_name' 
        AND ENGINE = 'MyISAM'";

    $rs = mysql_query($sql);

    while($row = mysql_fetch_array($rs))
    {
        $tbl = $row[0];
        $sql = "ALTER TABLE `$tbl` ENGINE=INNODB";
        mysql_query($sql);
    }
?>

[vestacp89]

mysql / phpmyadmin - http://dev.mysql.com/doc/refman/5.6/en/ ... nnodb.html

or magic php scripts (source)

Code: Select all

<?php
    // connect your database here first 
    // 

    // Actual code starts here 

    $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA = 'your_database_name' 
        AND ENGINE = 'MyISAM'";

    $rs = mysql_query($sql);

    while($row = mysql_fetch_array($rs))
    {
        $tbl = $row[0];
        $sql = "ALTER TABLE `$tbl` ENGINE=INNODB";
        mysql_query($sql);
    }
?>

Hello,

this script:

Code: Select all

<?php
    // connect your database here first 
    // 

    // Actual code starts here 

    $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA = 'your_database_name' 
        AND ENGINE = 'MyISAM'";

    $rs = mysql_query($sql);

    while($row = mysql_fetch_array($rs))
    {
        $tbl = $row[0];
        $sql = "ALTER TABLE `$tbl` ENGINE=INNODB";
        mysql_query($sql);
    }
?>

I need to paste this code make .php file and run ?
I don't know what all i need edit in this code,
can you pls tell what i need to edit in code, my database name is ''auto_db'' ?

Thanks.

[skurudo]

Too many manuals in network, make backup and try:

https://gist.github.com/calevans/9943627

https://pantheon.io/blog/moving-mysql-t ... sam-innodb

http://www.woblag.com/2012/10/batch-con ... nnodb.html