如何将所有表从MyISAM转换为InnoDB? [英] How to convert all tables from MyISAM into InnoDB?

问题描述

我知道我可以单独发布一个alter table来将表存储从MyISAM更改为InnoDB.

I know I can issue an alter table individually to change the table storage from MyISAM to InnoDB.

我想知道是否有一种方法可以将它们全部快速更改为InnoDB?

I am wondering if there is a way to quickly change all of them to InnoDB?

推荐答案

<?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);
    }
?>

这篇关于如何将所有表从MyISAM转换为InnoDB?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！