Size of MySQL Databases Shown as 0MB in cPanel

Size of MySQL Databases Shown as 0MB in cPanel

Sometimes, when you log into cPanel, you’ll see non-empty MySQL databases showing 0MB as its size. Those databases actually contain tables and details, but the size is always shown as 0MB.

 

Size of MySQL Databases Shown as 0MB in cPanel

 

Steps to fix this issue from command line

1) Logon to server using SSH.

2) Reset the value of disk_usage_include_sqldbs from 0 to 1 in cPanel configuration file.

# vi /var/cpanel/cpanel.config

disk_usage_include_sqldbs=1

3) Run the script below to update the database cache

# /scripts/update_db_cache

 

 Steps to fix the database size issue from WHM

1) Login to WHM.

2) Navigate to ‘Tweak Settings’ under ‘Server Configuration’.

Size of MySQL Databases Shown as 0MB in cPanel

 

3) Navigate to ‘SQL’ section and you can see the option’ Include databases in disk usage calculations’. Turn it on.

Size of MySQL Databases Shown as 0MB in cPanel

 

4) Click ‘Save’ button to enable the changes.

If you need any further help please contact our support department.

  • 0

How to Block Bots using Robots.txt File?

How to Block Bots using Robots.txt File? The robots.txt file is a simple text file placed on...

PageSpeed on cPanel Server

PageSpeed on cPanel Server PageSpeed on cPanel Server PageSpeed (mod_pagespeed) is a module for...

How to change cPanel logout URL

How to change cPanel logout URL Do you know that it is possible to change cPanel logout URL any...

How to Change cPanel Style

How to Change cPanel Style How to Change cPanel Style cPanel is the most popular control panel...