Answer Posted / pandu
Run the below query you can get the Data Base Size in MySQL.
If you run the query which is given below in MySQL Query
Browser then you will get the two columns first will display
the Data Base Name and the second will display the Data Base
Size in MB.
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 ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use sum function in where clause in mysql?
In which language mysql has been written?
Is mongodb faster than mysql?
How do stored procedures work?
How do I run mysql?
How to enter microseconds in sql statements?
Is number a datatype in mysql?
How can you move the master database
How do I view tables in mysql workbench?
What are the different types of triggers in mysql?
How to create a new table in mysql?
How is mysql database stored?
How to create trigger in mysql phpmyadmin?
can you elaborate on blob and text in mysql? : Mysql dba
Why we use mysqli instead of mysql?