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 allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What are the 5 r's of managing behaviors?
How do I find the database name in mysql?
How to create trigger in mysql workbench?
How does mysql store data?
What is the difference between a database and a table?
How to concatenate two character strings?
How to dump one database for backup.
What is mysql in dbms?
What command is used to delete the data from the table without deleting the table structure?
How to upload a large file through phpmyadmin in mysql?
What is difference between mongodb and mysql?
How to get help information from the server?
What is the datatype for password in mysql?
What is an example of a delimiter?