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