{{parent page="MySQL"}}

===Mysql check database size===

%%
<?
mysql_connect("localhost", "root", "xxxx");
mysql_select_db("reporting");

$result = mysql_query("show table status");

$size = 0;
$out = "";
while($row = mysql_fetch_array($result)) {
$size += $row["Data_length"];
$out .= $row["Name"] .": ".
round(($row["Data_length"]/1024)/1024, 2) ."MB\n";
}

$size = round(($size/1024)/1024, 1);

echo $out ."<br>\n";
echo "Total MySQL db size in MB: $size";
?>
%%