Hi,
does anyone knows the command to show the size of the SQL-database?
thanks,
How do I find the size of my database?
Re: How do I find the size of my database?
With MySQL you can give the following command:
This tells the size in MB.
But you can install phpMyAdmin (http://www.phpmyadmin.net), if you want to easily manipulate MySQL databases.
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;
But you can install phpMyAdmin (http://www.phpmyadmin.net), if you want to easily manipulate MySQL databases.