størrelse på DB

http://forums.devshed.com/t87958/s7e9bf77d24816d7071693b6b90b2f079.html

$db = "database";
$query ="SHOW TABLE STATUS FROM " . $db;
$result = mysql_query($query)
            or die(mysql_error());

if (@mysql_num_rows($result)) {
                while ($row = mysql_fetch_array($result)) {
                    $dbs_array[$db][1] += $row['Data_length'];
                    $dbs_array[$db][2] += $row['Index_length'];
                }
                $dbs_array[$db][3]    = $dbs_array[$db][1] + $dbs_array[$db][2];
                $total_array[1]        += $dbs_array[$db][1];
                $total_array[2]        += $dbs_array[$db][2];
                $total_array[3]        += $dbs_array[$db][3];
            } // end if
mysql_close($conn);
$bytes = $total_array[3];
$kb = $bytes/1024;
$mb = $kb/1024;
print "$db database indeholder ialt: $bytes bytes</br>";
print "$db database indeholder ialt: $kb kilobytes</br>";
print "$db database indeholder ialt: $mb megabytes</br>";

Access denied for user: '@localhost' to database 'xxxxx'

Jeg fik det igang