Webmaster2020.com

Posted: **Wed Sep 05, 2012 3:07 pm**

Hi,

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

thanks,

Posted: **Wed Sep 05, 2012 3:49 pm**

With MySQL you can give the following command:

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.

Webmaster2020.com

How do I find the size of my database?

How do I find the size of my database?

Re: How do I find the size of my database?