PHP Code: MySQL-Datenbank in MB
Gibt die Grösse einer MySQL-Datenbank in MB aus.
<?php
function database_size() {
$result = mysql_list_tables($this->db,
$this->linkid);
$anzahl = mysql_num_rows($result);
$size = 0;
for ($i=0; $i < $anzahl; $i++) {
$table_name = mysql_tablename($result, $i);
$sql = mysql_query("SHOW TABLE STATUS FROM ".$this->db." LIKE '".$table_name."'");
$data = mysql_fetch_array($sql);
$size += (($data['Index_length'] + $data['Data_length'])/1024/1024);
};
return number_format($size, 4)." MB";
}
?>
Tags: Datenbank, Funktion, MB, MySQL, PHP