+91 88 00 563434 [email protected] Blog open-book Knowledge Base

Find Solutions in Our Knowledge Base

The size of MySQL databases is displayed as 0MB in cPanel

You are here:
Sharing is Caring

Upon logging into cPanel, you may occasionally encounter MySQL databases that contain tables and details but still display a size of 0MB.

0mb

Steps to resolve this issue from the command line:

1) SSH into the server.

2) In the cPanel configuration file, modify the value of disk_usage_include_sqldbs from 0 to 1.

# vi /var/cpanel/cpanel.config

disk_usage_include_sqldbs=1

3) Execute the following script to update the database cache.

# /scripts/update_db_cache

 

 Steps to fix the database size issue from WHM:

1) Login to WHM.

2) Go to ‘Server Configuration’ and select ‘Tweak Settings’.

Change default language

3) Under the ‘SQL’ section, locate the option ‘Include databases in disk usage calculations’ and enable it.

MySQL databases

4) Save the changes by clicking the ‘Save’ button.

If you require further assistance, please reach out to our support department.

cPanel Reports MySQL Database Size as 0MB


Sharing is Caring

Leave a Comment

Table of Contents