read mysql db size

[Anon]

Is there a way to view/read the size of a mysql database ??

Have searched through the mysql documentation but cannot find anything there !

Thanks,
Peter

[tasistro]

how about running the following sql

show table status;

returns all info of all tables in currently selected dbase

add up field Data_length+Index_length for all rows, you get all the bytes used by your dbase

Saludos
Gerardo

[Anon]

Not sure how to construct such a query, would it go something like this:

$result = mysql_query("show table status");
if(mysql_num_tables($result)==1) { //<
while($tables=mysql_fetch_fields($result,MYSQL_ASSOC)) {
$Data_length+=$Data_length;
$Index_length+=$Index_length;
}
$dbsize=$Data_length + $Index_length);

Many thanks,
Peter