Convert all tables from MyISAM to InnoDB using PHP

[2Fast2BCn]

Normally when you create one table in MySQL Storage Engine, you will have many styles to choose from. Including 3 types of storage that most use are InnoDB, MyISAM and Memory.

If for any reasons you need to change the type from MyISAM to InnoDB or vice versa. PHP will help you do that.

<?php
// connect your database here first
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = 'root';
 
    $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
    $dbname = 'databasename';
    mysql_select_db($dbname);
 
// Actual code starts here
    $sql = "SHOW tables";
    $rs = mysql_query($sql);
    while($row = mysql_fetch_array($rs))
    {
        $tbl = $row[0];
        $sql = "ALTER TABLE $tbl ENGINE=INNODB";
        mysql_query($sql);
    }
?>

Now your task is change the parameters such as $dbhost, $dbuser, $dbpass, $dbname to match the information on your hosting.

Hope to hear other ways from all of you here.

 

[Web Marketing Tool]

One note, this code won't work in php 7. mysql_* functions are no longer supported. mysqli is the closest alternative as far as being able to easily convert this code to using a supported method.

 

[Tshepo]

Tshepo

I'm also caring on this problem, what functions can I use to instead for mysql_* functions in PHP 7?