MySQL Modify table engine: PHP bulk conversion MySQL table engine

Some times you may need to bulk convert the MySQL table engine, as follows for PHP operations
<?php
/**
* Bulk conversion MySQL table engine
*/
Error_reporting (E_all);
Database Connection Configuration
$host = ' localhost ';
$username = ' root ';
$passwd = ';
$database = ' Test ';
To convert the library name configuration, the multi-Library transformation adds configuration elements
$configs = Array ($database);
Transformation Configuration
$convert _rule = Array (
' From ' => ' InnoDB ',
' To ' => ' MyISAM '
);
Mysql_engine_convert ();
/**
* Conversion function
*/
function Mysql_engine_convert ()
{
Global $host, $username, $passwd, $configs, $convert _rule;
if (($conn = mysql_connect ($host, $username, $passwd))!== false)
{
foreach ($configs as $db _name)
{
mysql_select_db ($db _name) or exit (' not found DB: '. $db _name);
$tables = mysql_query ("Show full Tables");
while ($table = Mysql_fetch_row ($tables))
{
if ($table [1] = = ' view ') continue;
$sql = "Show Table status from {$db _name} where name= ' {$table [0]} '";
if ($result = mysql_query ($sql))
{
$table _status = mysql_fetch_row ($result);
if (Strtolower ($table _status[1]) = = Strtolower ($convert _rule[' from '))
mysql_query ("ALTER TABLE {$table [0]} engine = {$convert _rule[' to '}");
}
}
echo $db _name, ': All Tables engine are ', $convert _rule[' to '], "\ n";
}
} else {
echo "DB error\n";
}
This article links http://www.cxybl.com/html/wlbc/Php/20120607/28510.html