Linux SFS3
http://163.23.89.100/pub/sfs_tool/InnoDB2.txt
<html><head> <title>轉換InnoDB資料表為MyISAM</title> <meta http-equiv='content-type' content='text/html; charset=UTF-8'> <body> 轉換InnoDB資料表為MyISAM <?php //下載本檔到主機後，改副檔名為.php ，再修改下面四行資訊，才從網頁上執行本程式。 $MySQL['Db'] ='sfs3';//資料庫名稱 $MySQL['User'] ='root';//資料庫使用者 $MySQL['Pass'] ='stu123';//--要更改,資料庫密碼 $MySQL['Host'] ='localhost';//資料庫主機 try { $CONN =new PDO('mysql:host='.$MySQL['Host'].';dbname='.$MySQL['Db'], $MySQL['User'],$MySQL['Pass']); } catch (PDOException $e) { die("<center><h2>無法連結資料庫</h2></center>"); } if ($_GET['Go']=='Yes'){ //不轉換的資料表 $a=array('student_view','teacher_course_view','teacher_post_view'); $SQL="SHOW TABLE STATUS FROM `{$MySQL['Db']}` "; $rs=$CONN->query($SQL) or die($SQL); $arr=$rs->fetchAll(); //echo "<pre>";print_r($arr);die(); foreach ($arr as $row){ //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"; $rs=$CONN->query($SQL) or die($SQL); echo $SQL.'<br>'; } } $SQL="flush privileges"; $rs=$CONN->query($SQL); //header("Location:".$_SERVER['PHP_SELF']); } echo "<a href='{$_SERVER['PHP_SELF']}?Go=Yes'><h2>開始資料庫InnoDB轉換</h2></a>";