Log in or Sign up

Repair and optimize a database

Discussion in 'Databases' started by rive0108, Feb 8, 2010.

rive0108 Peon

Messages:

119

Likes Received:

1

Best Answers:

0

Trophy Points:

0

#1

Here is a script that will repair and optimize a database-

place in in a php file on your public_html, and setup a cron to run it daily:

<?php
//GSS
$server = "localhost";
$user = "dbuser";
$pwd = "dbpass";
$dbName = "dbname";

$link = mysql_connect($server, $user, $pwd);
if (!$link) {
die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db($dbName, $link);
if (!$db_selected) {
die ('Can\'t use $dbName : ' . mysql_error());
}

// Find the names of all tables in the selected db.
$alltables = mysql_query("SHOW TABLES");

// Go through all tables.
while ($table = mysql_fetch_assoc($alltables)) {
foreach ($table as $db => $tablename) {
// Perform the magic â€œOPTIMIZE" on every table in the db.
mysql_query("OPTIMIZE TABLE ".$tablename)
or die(mysql_error());
}
}

mysql_close($link); ?>
Click to expand...

rive0108, Feb 8, 2010 IP
Sparticus013 Peon

Messages:

58

Likes Received:

1

Best Answers:

0

Trophy Points:

0

#2

Hey thanks im gonna test it.

Sparticus013, Feb 9, 2010 IP

(You must log in or sign up to reply here.)