Size of a MySQL Database

[Jonathan Pokou]

Hi MySQL users,

Could you please tell me how to get the total size of all the MySQL databases on one server. From my understanding, the following query allows me to get the result that i am looking for:

SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

But the thing is on MySQL 4.1 the database information_schema doesn't exist so the previous query doesn't work... Is there a way to get the total database size on MySQL 4.1?

Thank you.