How do I find the size of my database?

[mister_v]

Hi,

does anyone knows the command to show the size of the SQL-database?

thanks,

[chris]

With MySQL you can give the following command:

Code: Select all

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

This tells the size in MB.

But you can install phpMyAdmin (http://www.phpmyadmin.net), if you want to easily manipulate MySQL databases.