Convert from MyISAM to InnoDB

convert_to_innodb.sh

        $sql = "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='%s' AND engine='MyISAM' AND table_name NOT IN (SELECT table_name FROM INFORMATION_SCHEMA.statistics WHERE index_type='FULLTEXT' AND table_schema='%s')";
        $result = $db->query(sprintf($sql,
                mysql_escape_string($instance->getName()),
                mysql_escape_string($instance->getName())
        ));
        while ($row = $db->fetch_array($result)) {
                $tables[] = $row[0];
        }

        foreach ($tables as $table) {
                if (in_array($table, $skip_tables)) {
                        continue;
                }
                $sql = sprintf("ALTER TABLE %s ENGINE=InnoDB", mysql_escape_string($table));
                syslog(LOG_NOTICE, sprintf("converting %s.%s to InnoDB", $instance->getDbName(), $table));
                if (!$db->query($sql)) {
                        syslog(LOG_NOTICE, sprintf("conversion of %s.%s failed because: '%s'",
                                $instance->getName(),
                                $table,
                                $db->geterrdesc()));
                }
        }