#!/usr/bin/php
<?php
$server = "localhost";
$user = "mysql-user";
$pwd = "password";
 
$link = mysql_connect($server, $user, $pwd);
if (!$link) {
  die('Could not connect: ' . mysql_error());
}
 
$q= mysql_query("SHOW DATABASES") or die(mysql_error());
 while ($dbName = mysql_fetch_array($q)) {
   if ($dbName[0] != "information_schema") {
     echo " + Selecting " . $dbName[0] . "\n";
     $db_selected = mysql_select_db($dbName[0], $link);
        if (!$db_selected) {
        die ('Can\'t use $dbName[0] : ' . mysql_error());
     }
 
     $alltables = mysql_query("SHOW TABLES") or die(mysql_error());
 
     while ($tableName = mysql_fetch_array($alltables)) {
        echo "   - Optimizing " . $tableName[0] . "\n";
        mysql_query("OPTIMIZE TABLE `".$tableName[0]."`") or die(mysql_error());
     }
   } else {
      echo " + Skipping " . $dbName[0] . "\n";
   }
}
 
mysql_close($link);
 
?>