Re: [RedRum] Getting the size of a mysql-database with perl?In reply to
Hmm .. there must be another trick - phpmyadmin 2.2x displays the size of tables and databases without knowing the path to mysql ... my knowledge about PHP is too poor to see how they do this ...
Re: [RedRum] Getting the size of a mysql-database with perl?In reply to
Just playing with this ... if i enter
SHOW TABLE STATUS FROM database
into phpmyadmin i'll get two values (per table) shown: Data_length & Index_length.
Added those two values are the total size of the table ... if we get those values for all tables we'll have the total size of the database ... works fine for me ..