MySQL DB size showing zero Mb in cPanel

Posted: 2p in MySQL

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
Comments
  1. Sreeram says:

    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