VOS3000 BLOG
VOS3000 installation and configuration details also how to use vos3000 with latest update
How to check vos3000 MySQL Database size
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;
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 buffe
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]#