Posted By

ginoplusio on 02/01/10

Tagged

mysql
php
table

Versions (?)

Last Edited at 02/01/10 05:44am

Statistics

Viewed 1230 times

Favorited by 1 user(s)

Related snippets

MySQLi repair and optimize tables

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function fixTables($conn,$dbname) {
	// search for all the tables of
	// a db and run repair and optimize
	// note: this can take a lot of time
	// if you have big/many tables.
	global $conn;
	if ( $rs = $conn->query("SHOW TABLES FROM $dbname") ) {
		while ( $r = $rs->fetch_array() ) {
			$conn->query("REPAIR TABLE {$r[0]}");
			$conn->query("OPTIMIZE TABLE {$r[0]}");
		}
		$rs->free();
	}
}