Pues eso, en esta entrada vamos a ver como calcular el tamaño de una base de datos MySql con php.
$connection = mysql_connect('DBSERVER', 'USER', 'PASSWORD'); if (!$connection) { die('CANT CONNECT'); } print calculateDataBaseSize('DATABASE_NAME', $connection); mysql_close($connection); function calculateDataBaseSize($database, $connection) { $tables = mysql_list_tables($database, $connection); $units = array(' B', ' KB', ' MB', ' GB', ' TB'); $status = -1; if (!$tables) { $status = -1; } else { $tbcount = mysql_num_rows($tables); $size = 0; for ($i=0; $i < $tbcount; $i++) { $tbname = mysql_tablename($tables, $i); $result = mysql_query("SHOW TABLE STATUS FROM ".$database." LIKE '".$tbname."'"); $data = mysql_fetch_array($result); $size += ($data['Index_length'] + $data['Data_length']); }; for ($i = 0; $size > 1024; $i++) { $size /= 1024; } $status = round($size, 2).$units[$i]; } return $status; } |