MySQL DB size showing zero Mb in cPanel

MySQL DB size showing zero Mb in cPanel

Sometimes we can see the mysql database size as zero in cPanel

Solution:-

vi /var/cpanel/cpanel.config
search for
disk_usage_include_sqldbs=0
and then make change to

disk_usage_include_sqldbs=1
If the parameter is not present, add it. Save the file and execute the following command:

/scripts/update_db_cache

This may take few minutes to get fixed if you have a large number of users with databases, but once done, you should be able see the database disk usage show up accurately in cPanel.

Advertisements

One thought on “MySQL DB size showing zero Mb in cPanel

  1. Hi,

    Sorry for contacting you this way. I was wondering if you would be interested in
    reviewing http://ubiq.co for your readers. It is a new web based MySQL reporting
    tool I’ve built. Happy to provide extended free usage to your readers.

    Regards,
    Sreeram

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s