Optimize All Tables In A MySQL Database

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.

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());

   }

}

?>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Optimize All Tables In A MySQL Database
Database Cashing tables results model -
dump Mysql database -
import Mysql database -
Creating a Database in MySQL -
IP Address Lookup in Bulk Using C-Sharp and MySQL Database -
Add two tables -
Generating Tables from XML by php -
Persisting a class into two tables -
need help in mysql -
connect to MYSQL from ASP -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com