";
if($db_host && $db_user){
mysql_connect("$db_host","$db_user","$db_password") or die("Error: No BD Connection");
$rs = mysql_query("show databases");
$db_names=array();
while($arr=mysql_fetch_array($rs)){
$db_names[]=$arr[0];
}
$post_name = isset($_POST['db_name']) ? $_POST['db_name'] : "";
foreach($db_names as $db_name) {
$selected="";
if ($db_name == $post_name) $selected=' selected ';
$db_select .="";
}
}
$db_select .= "";
?>
$fields){
if (in_array($t_name, $skip_tables)) {
$font_color = "red";
echo "
-- Table: $t_name => skipped! ";
continue;
}
$font_color = "black";
$query = "ALTER TABLE `$t_name` ENGINE = INNODB ";
if ($execute_queries && $process_type=='execute') {
mysql_query($query);
}
echo "
-- Table: $t_name $query ";
}
}
function DBColumns($source_db){
if (empty($source_db)) return array();
$db_check = @mysql_select_db ( $source_db );
$getTables = mysql_query("SHOW TABLES");
$tables = array();
while($row = mysql_fetch_row($getTables)){
$tables[] = $row[0];
}
$table_descriptions=array();
foreach($tables as $tablename){
$sql = "DESCRIBE $tablename";
$result =mysql_query($sql);
while($row = mysql_fetch_row($result) ){
$table_descriptions[$tablename][$row[0]] = array($row[0], $row[1]);
}
}
return $table_descriptions;
}
?>