How to check vos3000 MySQL Database size

Before transfer database to new server you want to know the vos3000db database size.For that you must login to the mysql and write below query or copy paste.

SELECT table_schema AS “Database name”, SUM(data_length + index_length) / 1024 / 1024 AS “Size (MB)” FROM information_schema.TABLES GROUP BY table_schema;

[root@www mysql]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.51a-community MySQL Community Edition (GPL)
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> SELECT table_schema AS “Database name”, SUM(data_length + index_length) / 1024 / 1024 AS “Size (MB)” FROM information_schema.TABLES GROUP BY table_schema;
+——————–+—————+
| Database name | Size (MB) |
+——————–+—————+
| information_schema | 0.00390625 |
| mysql | 0.49997520 |
| vos3000db | 8008.05074978 |
+——————–+—————+
3 rows in set (2.65 sec)

mysql> quit
Bye
[root@www mysql]#

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *