Looking for somewhere to host your site? Browse our PHP web hosts section!

Home > PHP Scripts > Optimize All Tables In A MySQL Database

Optimize All Tables In A MySQL Database

Description

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

The code


<?php


dbConnect
()

$alltables mysql_query("SHOW TABLES");

while (
$table mysql_fetch_assoc($alltables))
{

   foreach (
$table as $db => $tablename)
   {
       
mysql_query("OPTIMIZE TABLE '".$tablename."'")
           or die(
mysql_error());
   }
   
}

?>

Get the code

Download the file to your computer: Click here to get the file