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 ;

In which language it is written?

1010

---

What are the functions of commit and rollback statements?

1103

---

Which is better sqlite or mysql?

1117

---

How to use mysqldump to create a copy of the database?

1134

---

What is database in php mysql?

1039

---

Where is the myisam table stored?

1007

---

how we will Show selected records sorted in an ascending (asc) or descending (desc).

1029

---

How can you filter the duplicate data while retrieving records from the table?

947

---

How to create trigger in mysql workbench?

1036

---

What is relational database in mysql?

977

---

What is mysql data directory?

1051

---

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

935

---

How to create a new table in mysql?

1097

---

What are the advantages of myisam over innodb?

1020

---

Is mysql free for enterprise?

951

---