http://163.23.89.100/pub/sfs_tool/inno.txt
<html><head>
<meta http-equiv='content-type' content='text/html; charset=UTF-8'>
<?php
$mysql_host='localhost';
$mysql_user='root';
$mysql_pass='stu123';//--要更改資料庫密碼
$mysql_db='sfs3';//--不同時..要更改資料庫名稱
if ($_GET['Go']=='Yes'){
$a=array('student_view','teacher_course_view','teacher_post_view');
$link=mysql_pconnect($mysql_host,$mysql_user,$mysql_pass) or die("無法連線");
mysql_select_db($mysql_db,$link);
$SQL="SHOW TABLE STATUS FROM $mysql_db ";
$rs=mysql_query($SQL,$link) or die($SQL);
while ($row = mysql_fetch_array ($rs)){
//if ($row['Engine']!='MyISAM' and !in_array($row['Name'],$a)){
if ($row['Engine']=='InnoDB' and !in_array($row['Name'],$a)){
//$SQL="use ".$mysql_db.";ALTER TABLE `".$row['Name']."` ENGINE=MYISAM; flush privileges;";
$SQL="ALTER TABLE `".$row['Name']."` ENGINE=MYISAM";
$rs1=mysql_query($SQL,$link) or die($SQL);
echo $SQL.'<br>';
}
}
mysql_query("flush privileges",$link);
header("Location:".$_SERVER['PHP_SELF']);
}
echo "<a href='{$_SERVER['PHP_SELF']}?Go=Yes'><h2>開始資料庫InnoDB轉換</h2></a>";