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 do I find mysql location?
How to do login in mysql with unix shell.
What are the mysql database files stored in system ?
What is an example of a delimiter?
How to delete the repeated records from a table?
Which software is used for mysql?
what is constraints? Also explain the different types of constraints?
Can I copy mysql data directory?
How do I view tables in mysql workbench?
How do I edit a stored procedure in mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
Is primary key auto increment?
How to show all tables with 'mysql'?
How to find second highest salary from a table?
What is the latest version of php and mysql?