Skip to content

Instantly share code, notes, and snippets.

@markshust

markshust/mysql_myisam_to_innodb.php

Created February 25, 2014 17:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save markshust/9213270 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save markshust/9213270 to your computer and use it in GitHub Desktop.
Download ZIP
PHP script to convert MySQL tables from MyISAM to InnoDB
Raw
mysql_myisam_to_innodb.php
<?php
$conn = mysql_connect('server', 'username', 'password');
mysql_select_db('database', $conn);
$sql = "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine <> 'InnoDB'";
$rs = mysql_query($sql);
while ($row = mysql_fetch_array($rs)) {
$tbl = $row[0];
$sql = "ALTER TABLE $tbl ENGINE=INNODB";
mysql_query($sql);
}
@markshust
Copy link
Author

markshust commented Feb 25, 2014

Note, do not run this as root, otherwise it will try to update all database tables on your server, not just for the connected database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment