Empty a MySQL table
Monday, September 22nd, 2008TRUNCATE TABLE tablename
Archive for the ‘PHP’ Category
Repair MySQL Table with PHP
Monday, September 22nd, 2008<?
### Enter your username and password into the connection string: ###
$dbLink = mysql_connect(”localhost”, “username”, “password”) or die(”Unable to connect to the database.”);$sql = “show databases”;
$query = mysql_query($sql) or die(”error fetching database names”);
while ($rs=mysql_fetch_array($query)) {
//echo “Database: ” . $rs[’Database’] . “\n”;
mysql_select_db($rs[’Database’],$dbLink) or die(”Unable to select database: ” . $rs[’Database’]);
$sql = “show tables”;
$query2 = mysql_query($sql) or die(”error fetching table names”);
while ($rs2=mysql_fetch_array($query2)) {
$key = “Tables_in_” . $rs[’Database’];
//echo “Table: ” . $rs2[$key] . “\n”;
$sql = “repair table ” . $rs2[$key];
$query3 = mysql_query($sql) or die(”Error repairing a table - $sql”);
$rs3 = mysql_fetch_array($query3);
echo $rs3[’Table’] . ” | ” . $rs3[’Op’] . ” | ” . $rs3[’Msg_type’] . ” | ” . $rs3[’Msg_text’] . “\n”;
}
}
echo “Finished!\n”;
?>