How do I find the size of my database?

Post Reply
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

How do I find the size of my database?

Post by mister_v »

Hi,

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

thanks,
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

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

Post by 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.
Post Reply