Ottimizzare DataBase

[jaym]

Questo funziona controlla che il codice sia giusto:

$host = "localhost";
$user = "test";
$pass = "test";
$db_name = "test";

$db = mysql_connect($host, $user, $pass);
mysql_select_db($db_name, $db);

$SQL = "OPTIMIZE TABLE ";
$result = mysql_list_tables($db_name,$db);
$i = 0;
while ($i < mysql_num_rows($result)) {
    $name_table = mysql_table_name($result, $i);
    echo "Tabella: $name_table .....
";
    $SQL .= $name_table;
    $SQL .= ",";
    $i++;
}
$SQL = substr($SQL,0,strlen($SQL)-1);
$qry = mysql_query($SQL);
mysql_free_result($qry);