MySQL quotas showing 0.00MB in Cpanel

If your MySQL databases are all showing 0.00MB usage, you need to enable disk_usage_include_sqldbs.

1. Fix this issue via WHM

In Tweak Settings, enable “Calculate the disk usage of account MySQL and PostgreSQL databases.”

The default setting is “disabled”, or unchecked.

OR Fix this issue via SSH

you can enable MySQL database calculation via SSH by editing /var/cpanel/cpanel.config

You’ll want to search for

disk_usage_include_sqldbs=0

and change it to

disk_usage_include_sqldbs=1

If the parameter is not present, you’ll want to add it.

2. Run the update script to perform the initial calculations:

Finally, to calculate your MySQL and PostgreSQL database sizes, run the following:

# /scripts/update_db_cache