Change Storage Engine from INNODB to MyISAM for all tables

The following is a basic php script to change the storage engine used by all MySQL tables for a specified database to MyISAM from INNODB.



<?php

$conn = mysql_connect("localhost","username","password");
mysql_select_db("database-name",$conn);

$sql = "SHOW tables";
$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  $tbl = $row[0];
  $sql = "ALTER TABLE $tbl  ENGINE=myisam";
  mysql_query($sql);
}
?>


To change all tables from MyISAM to INNODB

<?php

$conn = mysql_connect("localhost","username","password");
mysql_select_db("database-name",$conn);

$sql = "SHOW tables";
$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  $tbl = $row[0];
  $sql = "ALTER TABLE $tbl  ENGINE=INNODB";
  mysql_query($sql);
}
?>

Comments

Popular posts from this blog

Basic Send Message to MQ with Java and IBM MQ JMS

Basic Receive Message to MQ with Java and IBM MQ JMS

Creating a simple Alert / Success Message with ASP.NET/VB using Bootstrap