Questo funziona controlla che il codice sia giusto:
Codice PHP:
$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);