Answer / 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 ;

Answer / ramkumar

1 bytes

How many groups of data types?

0 Answers  

---

Can I copy mysql data directory?

0 Answers  

---

What, if a table has one column defined as TIMESTAMP?

0 Answers  

---

How do I use mysql?

0 Answers  

---

How to shut down the server with 'mysqladmin'?

0 Answers  

---

What are HEAP tables in MySQL?

1 Answers  

---

how to find max salary from the database

3 Answers  

---

can you tell the order of sql select statement? : Mysql dba

0 Answers  

---

What is difference b/w composit key n primary key and forigion key?

4 Answers  

---

How to get current MySQL version?

0 Answers  

---

What is 'mysqlcheck'?

0 Answers  

---

How do I switch users in mysql?

0 Answers  

---