Linux SFS3
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>";