Skip to content

Instantly share code, notes, and snippets.

@malcomio malcomio/innodb.php
Created May 1, 2016

Embed
What would you like to do?
<?php
// your connection
mysql_connect("localhost","root","root");
mysql_select_db("d6");
// convert
$result = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($result)) {
foreach ($row as $key => $table) {
$query = "ALTER TABLE " . $table . " ENGINE=InnoDB;";
mysql_query($query);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.