This issue has been plaguing me ever since we moved to a VPS (at least I think so). The problem is when you go to view your MySQL databases in cPanel they appear as 0.00MB which is not correct (at least if you’ve got data & records in them)! Initially I thought either running /script/upcp –force or /scripts/fixquotas would resolve this, but it doesn’t. I sort of gave up after that, not sure why since I was able to resolve it within 5 minutes tonight. I ran a quick Google search and came across a cPanel forums post which linked to this blog article.

Essentially you just need to update a configuration option in the cPanel configuration file, then run a script, and you should be set!

Just open this file with your favorite text editor:

[~]# nano /var/cpanel/cpanel.config

Locate this line:

disk_usage_include_sqldbs=0

and change it to:

disk_usage_include_sqldbs=1

Then run this command:

[~]# /scripts/update_db_cache

Check your cPanel and it should be resolved!