better-testing

059.engines.php
View Options

			<?php

			$conn = $schema_conn;

			$tables = queryfx_all(
			$conn,
			"SELECT TABLE_SCHEMA db, TABLE_NAME tbl
			FROM information_schema.TABLES s
			WHERE s.TABLE_SCHEMA LIKE %>
			AND s.TABLE_NAME != 'search_documentfield'
			AND s.ENGINE != 'InnoDB'",
			'{$NAMESPACE}_');

			if (!$tables) {
			return;
			}

			echo pht(
			"There are %d tables using the MyISAM engine. These will now be converted ".
			"to InnoDB. This process may take a few minutes, please be patient.\n",
			count($tables));

			foreach ($tables as $table) {
			$name = $table['db'].'.'.$table['tbl'];
			echo pht('Converting %s...', $name)."\n";
			queryfx(
			$conn,
			'ALTER TABLE %T.%T ENGINE=InnoDB',
			$table['db'],
			$table['tbl']);
			}
			echo pht('Done!')."\n";