VOS3000 BLOG

VOS3000 installation and configuration details also how to use vos3000 with latest update

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form

How to check vos3000 MySQL Database size

Posted by on in Blog
  • Font size: Larger Smaller
  • Hits: 3456
  • Print

voip server rent cheek

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)

Voip server rent mobile dialer

/ 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]#

 

0