Differential D9431 Diff 22523 resources/sql/patches/059.engines.php

Changeset View

Standalone View

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

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